MySQL 8.0

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

select version();


version()


8.0.30


create table mytable(id int,mycolumn  varchar(20));
insert into mytable values(1,'car');
insert into mytable values(2,'bus');
insert into mytable values(3,'auto');
insert into mytable values(4,'Aeroplane');
insert into mytable values(5,'jet');
insert into mytable values(6,'jeep');
insert into mytable values(7,'rocket');
insert into mytable values(8,'bike');
insert into mytable values(9,'bicycle');
insert into mytable values(10,'random');

select * from mytable;


id
mycolumn


1
car

2
bus

3
auto

4
Aeroplane

5
jet

6
jeep

7
rocket

8
bike

9
bicycle

10
random


with cte as (
   select *, FLOOR(RAND()*(10-1+1))+1  as n
   from mytable
)
update mytable m join cte c on c.id=m.id  set m.mycolumn = ELT(c.n, 'Roger','Steve','Hulk','Jill','Thor','John','Arun','Mike','Bella','Mark')

Rows matched: 10  Changed: 10  Warnings: 0


select * from mytable


id
mycolumn


1
Thor

2
Steve

3
Thor

4
Arun

5
Steve

6
John

7
Thor

8
John

9
John

10
Mike

id	mycolumn
1	car
2	bus
3	auto
4	Aeroplane
5	jet
6	jeep
7	rocket
8	bike
9	bicycle
10	random