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