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