Database error: Invalid SQL: SELECT distinct id, name, is_available, strength, qty, qty_unit, qty_packages, is_prescription, retail_usd3, show_qty_button from drugs where ( (name LIKE 'ST.%') OR (name LIKE '% ST.%') OR (name LIKE '%(ST.%') OR (name LIKE '%-ST.%')) AND ( (name LIKE 'JOHN'S%') OR (name LIKE '% JOHN'S%') OR (name LIKE '%(JOHN'S%') OR (name LIKE '%-JOHN'S%')) AND ( (name LIKE 'WORT%') OR (name LIKE '% WORT%') OR (name LIKE '%(WORT%') OR (name LIKE '%-WORT%')) ORDER BY name, strength, qty MySQL Error: 1064 (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 'S%') OR (name LIKE '% JOHN'S%') OR (name LIKE '%(JOHN'S%') OR (name LIKE '%-JOHN' at line 1) Database error: Invalid SQL: SELECT distinct id, name, is_available, strength, qty, qty_unit, qty_packages, retail_usd3, show_qty_button, is_prescription from drugs where name LIKE '%ST.%' AND name LIKE '%JOHN'S%' AND name LIKE '%WORT%' ORDER BY name, strength, qty MySQL Error: 1064 (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 'S%' AND name LIKE '%WORT%' ORDER BY name, strength, qty' at line 1) Database error: next_record called with no query pending. MySQL Error: 1064 (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 'S%' AND name LIKE '%WORT%' ORDER BY name, strength, qty' at line 1) Canada Drug Mart