Pour nos amis nordiste....

Code: Select all

UPDATE
  oc_zone z
JOIN
  oc_country c ON c.country_id = z.country_id
SET
  z.name = 'Haut de France'
WHERE
  z.name = 'Nord'
  AND c.name LIKE 'France%';