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