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