SELECT * FROM JT_City WHERE (REPLACE(sCityName,'/ ','')='Kianggeh Bandar'   AND iProvinceID =Brunei ) OR (REPLACE(sCityName,'/',' ')='Kianggeh Bandar'  AND iProvinceID =Brunei);Unknown column 'Brunei' in 'where clause'