How to replace the first match from the left head?

For example,

UPDATE `medal` 
  SET `picture` = REPLACE(`picture`, 'https://img.xxx.com/', 'https://res.xxx.com/')
WHERE `picture` LIKE 'https://img.xxx.com/%'
;