MySQL Select names with last names starting with certain letter

Question

I have a MySQL database with a field Name which contains full names. To select all people with last names starting with a particular letter, let's say A for this example, I use the following query: SELECT * FROM db WHERE Name LIKE '% A%'. However, this also selects users who have a middle name starting with A. Is there anyway to alter this query so that only a last name starting in A will be selected?

Answer 1

SELECT * FROM db WHERE Name REGEX ' A[-[:alnum:]'']*$'

Answer 2

Ignacio's Regex works and is a lot more flexible - you could also use something like this if Regex completely confuses you:

SELECT * FROM db WHERE LEFT(SUBSTRING_INDEX(Name, ' ', -1), 1) = 'A'

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html