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