SELECT * FROM villes_france_free WHERE (ville_nom_soundex=SOUNDEX('L'Argentiere-la-Bessee') OR ville_nom_reel LIKE 'L'Argentiere-la-Bessee' OR ( ville_nom_alt !='' AND ville_nom_alt LIKE '%L'Argentiere-la-Bessee%' )) and ville_code_postal LIKE '%05120%' 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 '-la-Bessee') OR ville_nom_reel LIKE 'L'Argentiere-la-Bess' at line 2