Erreur SQL !
SELECT region from villes vi where REPLACE(REPLACE(vi.region, '\'', '-'), ' ', '-') like 'la-tour-en-jarez' COLLATE latin1_swedish_ci group by region limit 0,1