Search in SQL where string starts with X

Question

Well i currently want to do a search engine with SQL and PHP. I crrently use the following query:

SELECT * FROM info WHERE name LIKE '%$q%' LIMIT 10

But i want to select the info with 'name' that start with $q, not the ones that cointain $q.

Answer 1

Simply remove the first wildcard (%):

SELECT * FROM info WHERE name LIKE 'X%' LIMIT 10