select * from cottages where (CottCounty = '8' Attractions like '%Upton%' OR CottTown like '%Upton%' ) and CottCountry=1 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 'Attractions like '%Upton%' OR CottTown like '%Upton%' ) and CottCountry=1' at line 1