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