MySQL Like Expression problem

[interactive]

Alright I don't know what the problem is, maybe I'm just stupid. But here goes:

SELECT * FROM domains WHERE tld='com' AND date !='' AND domain LIKE "%a" 

That works and selects rows that end with a

SELECT * FROM domains WHERE tld='com' AND date !='' AND domain LIKE "a%" 

That does not work, it should select rows that begin with a but doesn't Now I know there are records that begin with a so whats the problem? Thanks

[stolzyboy]

are you receiving any errors, or just no results, try using mysql_error() to let the script tell you where it thinks something is wrong

[interactive]

I'm not recieving any errors and I'm using mysql_error. Like I said the first query works the second which is basicly the same just the positioning of %a switches to a%.