MySQL 8.0

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

CREATE TABLE tab (
  `caseID` int(11) NOT NULL,
  `groupVarian` varchar(255) NOT NULL
)




INSERT INTO tab (`caseID`, `groupVarian`) VALUES
(1, 'A,B,C,D,E'),
(2, 'A,B,N,O,P'),
(3, 'A,B,N,O,P'),
(4, 'A,B,C,D,F'),
(5, 'A,B,C,D,E');
SELECT *, CONCAT('v', DENSE_RANK() OVER(ORDER BY groupVarian)) AS namevarian
FROM tab
ORDER BY CaseID


caseID
groupVarian
namevarian


1
A,B,C,D,E
v1

2
A,B,N,O,P
v3

3
A,B,N,O,P
v3

4
A,B,C,D,F
v2

5
A,B,C,D,E
v1

`caseID`	`groupVarian`	`namevarian`
`1`	`A,B,C,D,E`	`v1`
`2`	`A,B,N,O,P`	`v3`
`3`	`A,B,N,O,P`	`v3`
`4`	`A,B,C,D,F`	`v2`
`5`	`A,B,C,D,E`	`v1`