MySQL 8.0

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

CREATE TABLE test (id SERIAL PRIMARY KEY, tags VARCHAR(255));
INSERT INTO test (tags) VALUES
('tag-1,tag-2,tag-3,tag-4,tag-5'),
('tag-6,tag-7,tag-8,tag-9'),
('tag-10,tag-11,tag-12'),
('tag-13,tag-14'),
('tag-15'),
('');
SELECT * FROM test;

Records: 6  Duplicates: 0  Warnings: 0




id
tags


1
tag-1,tag-2,tag-3,tag-4,tag-5

2
tag-6,tag-7,tag-8,tag-9

3
tag-10,tag-11,tag-12

4
tag-13,tag-14

5
tag-15

6



SELECT test.id, GROUP_CONCAT(jsontable.value ORDER BY RAND()) shuffled_tags
FROM test
CROSS JOIN JSON_TABLE( CONCAT('["', REPLACE(test.tags, ',', '","'), '"]'),
                       "$[*]" COLUMNS( value VARCHAR(254) PATH "$" )
                     ) AS jsontable
GROUP BY test.id;


id
shuffled_tags


1
tag-4,tag-3,tag-2,tag-1,tag-5

2
tag-9,tag-8,tag-6,tag-7

3
tag-12,tag-11,tag-10

4
tag-13,tag-14

5
tag-15

6



UPDATE test, ( SELECT test.id, GROUP_CONCAT(jsontable.value ORDER BY RAND()) tags
               FROM test
               CROSS JOIN JSON_TABLE( CONCAT('["', REPLACE(test.tags, ',', '","'), '"]'),
                                      "$[*]" COLUMNS( value VARCHAR(254) PATH "$" )
                                    ) AS jsontable
               GROUP BY test.id ) shuffled
SET test.tags = shuffled.tags
WHERE test.id = shuffled.id;
SELECT * FROM test;

Rows matched: 6  Changed: 4  Warnings: 0




id
tags


1
tag-4,tag-3,tag-5,tag-2,tag-1

2
tag-8,tag-9,tag-7,tag-6

3
tag-12,tag-11,tag-10

4
tag-14,tag-13

5
tag-15

6

id	tags
1	tag-1,tag-2,tag-3,tag-4,tag-5
2	tag-6,tag-7,tag-8,tag-9
3	tag-10,tag-11,tag-12
4	tag-13,tag-14
5	tag-15
6

id	shuffled_tags
1	tag-4,tag-3,tag-2,tag-1,tag-5
2	tag-9,tag-8,tag-6,tag-7
3	tag-12,tag-11,tag-10
4	tag-13,tag-14
5	tag-15
6

id	tags
1	tag-4,tag-3,tag-5,tag-2,tag-1
2	tag-8,tag-9,tag-7,tag-6
3	tag-12,tag-11,tag-10
4	tag-14,tag-13
5	tag-15
6