select * from allproducts where REFINE 1=1 and product_name like '%%'  order by rand() :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 '1=1 and product_name like '%%'  order by rand()' at line 1