title: MySQL Select names with last names starting with certain letter
body: <p>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: <code>SELECT * FROM db WHERE Name LIKE '% A%'</code>.  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? </p>