select * from allproducts where REFINE 1=1 and product_name like '%Maternity Straight Leg Trousers with Belt%'  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 '%Maternity Straight Leg Trousers with Belt%'  order b' at line 1