[AbsoluteMonkey]

Actually, the best way to do it is to use the 'LIKE' comparison to the `name` field.
Something like:
SELECT * WHERE `name` LIKE 'A%'; <-- should return all rows that start with 'A'.