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