Erreur SQL !
SELECT region from villes vi where REPLACE(REPLACE(vi.region, '\'', '-'), ' ', '-') like 'le-revest-les-eaux' COLLATE latin1_swedish_ci group by region limit 0,1