SELECT * FROM villes_france_free WHERE
(ville_nom_soundex=SOUNDEX('Saint-Martin-d'Heres')
OR ville_nom_reel LIKE 'Saint-Martin-d'Heres'
OR ( ville_nom_alt !='' AND ville_nom_alt LIKE '%Saint-Martin-d'Heres%' ))
and ville_code_postal LIKE '%38400%' LIMIT 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')
OR ville_nom_reel LIKE 'Saint-Martin-d'Heres'
' at line 2