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