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