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