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