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