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