SELECT LIKE search term

[Craig Hopson]

hi guys i am having trouble with the syntax of a query here is what i have not shore where to go from here

select * from `jcow_accounts` WHERE 1 AND (username LIKE craig% OR email LIKE craig% OR fullname LIKE craig%) AND birthyear>1953 AND birthyear<1995 AND gender=0 and !hide_me order by lastlogin DESC LIMIT 20

Thanks

Edited May 20, 2013 by Craig Hopson

[Stream]

I think you should use quote birthyear<"1995"

[niche]

Please see this link for an example. http://www.w3schools.com/sql/sql_like.asp