The following SQL selects all the rows where columnname starts with the letter A, switch the letter or make it a variable and get the results you need.

SELECT * FROM table WHERE columnname LIKE 'A%'

Tags: mysql