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