Erreur SQL !<br />SELECT region from
villes vi 
where REPLACE(REPLACE(vi.region, '\'', '-'), ' ', '-') like 'rouen' COLLATE utf8mb4_general_ci  
group by region
limit 0,1
<br />