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