SELECT * FROM JT_City WHERE (REPLACE(sCityName,'/ ','')='Hai Ba Trung District'   AND iProvinceID =Hanoi ) OR (REPLACE(sCityName,'/',' ')='Hai Ba Trung District'  AND iProvinceID =Hanoi);Unknown column 'Hanoi' in 'where clause'