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