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