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