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