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