Erreur SQL !
SELECT numregion, region from villes v where REPLACE(REPLACE(v.region, '\'', '-'), ' ', '-') like 'bosc-hyons' COLLATE utf8mb4_general_ci order by v.id desc