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