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