select * from allproducts where REFINE 1=1 and product_name like '%Black evening wear maternity trousers%' 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 '%Black evening wear maternity trousers%' order by ra' at line 1