what wrong with 1=1 ?

[Nakata kokuyo]

good day to all ,

can i know why i having error when i use the following query in my java application with mysql db ?

 SELECT * from tbl_user where 1=1 userid like '%user%'

i get the following error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'userid like '%user%'' at line 1 

[Jan Cumps]

Originally posted by Nakata kokuyo:
good day to all ,

can i know why i having error when i use the following query in my java application with mysql db ?
...

 SELECT * from tbl_user where 1=1 userid like '%user%'

...

You forgot the AND between two where clauses.

SELECT * from tbl_user where 1=1 [B]AND [/B]userid like '%user%'

Regards, Jan