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