Erreur SQL !
SELECT region from villes vi where REPLACE(REPLACE(vi.region, '\'', '-'), ' ', '-') like 'saint-hilaire-de-lusignan' COLLATE latin1_swedish_ci group by region limit 0,1