MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT VERSION();


VERSION()


8.0.23


CREATE TABLE IF NOT EXISTS `tablename` (
  `id` int(11) unsigned NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `tablename`
VALUES
(1, '[ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame]'),
(2, 'dsadad asd ad [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] fdg dgh h fh '),
(3, 'dsadad asd ad [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] fdg dgh h fh [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] sdada');
SELECT * FROM `tablename`;


id
message


1
[ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame]

2
dsadad asd ad [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] fdg dgh h fh

3
dsadad asd ad [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] fdg dgh h fh [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] sdada


UPDATE `tablename` SET `message` = REGEXP_REPLACE(`message`, 'ame="https:\/\/www\.youtube\.com\/watch(.*?)v=(.*?)"(.*?)\/ame', 'MEDIA=youtube]$2[/MEDIA');
SELECT * FROM `tablename`;


id
message


1
[MEDIA=youtube]GEPvsn6JA_c[/MEDIA]

2
dsadad asd ad [MEDIA=youtube]GEPvsn6JA_c[/MEDIA] fdg dgh h fh

3
dsadad asd ad [MEDIA=youtube]GEPvsn6JA_c[/MEDIA] fdg dgh h fh [MEDIA=youtube]GEPvsn6JA_c[/MEDIA] sdada

id	message
1	[ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame]
2	dsadad asd ad [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] fdg dgh h fh
3	dsadad asd ad [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] fdg dgh h fh [ame="https://www.youtube.com/watch?v=GEPvsn6JA_c"]lalala lalalal alala[/ame] sdada

id	message
1	[MEDIA=youtube]GEPvsn6JA_c[/MEDIA]
2	dsadad asd ad [MEDIA=youtube]GEPvsn6JA_c[/MEDIA] fdg dgh h fh
3	dsadad asd ad [MEDIA=youtube]GEPvsn6JA_c[/MEDIA] fdg dgh h fh [MEDIA=youtube]GEPvsn6JA_c[/MEDIA] sdada