Welcome to WebmasterWorld Guest from 18.104.22.168
SELECT * FROM table WHERE field LIKE 'a%' Returns 0 <==
SELECT * FROM table WHERE field LIKE '%a%' Returns 1
SELECT * FROM table WHERE field LIKE '%a' Returns 1
field = aba
im not sure if its to do with collation,
Anyway i played around and found it was only that field the problem lies on, tried recreating the table, same problem, i copied it to a new database and still wouldnt work. so i tried creating a fresh table on a new database and it works ok now?
Strange! thanks for your help, ive kept the old database and will dig deeper tomorrow and try to find whats causing it.