Help on MySQL query

[luisfalcon]

Hi folks..

Which would be the syntax for a MySQL query that does something like this:

"SELECT * FROM domains WHERE domain STARTS WITH 'a'"

I mean, select something where the value starts with a given letter.

Thanks in advance!

[Travis]

"SELECT * FROM domains WHERE domain LIKE 'a%'" 

I believe thats it.

[luisfalcon]

Yep, that was it... thanks dude!