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