MySQL 8.0

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

create table test (
id int,
name varchar(20),
color varchar(20)
);


insert into test values 
(1,'FirstCar','White'),
(2,'SecondCar','Yellow'),
(3,'ThirdCar','Red'),
(4,'FourthCar','White'),
(5,'FifthCar','Green'),
(6,'SixthCar','Blue');
SELECT * FROM test; 


id
name
color


1
FirstCar
White

2
SecondCar
Yellow

3
ThirdCar
Red

4
FourthCar
White

5
FifthCar
Green

6
SixthCar
Blue


UPDATE test set name = CONCAT(name,'_123') WHERE name IN ('SecondCar','FourthCar','SixthCar');
SELECT * FROM test; 


id
name
color


1
FirstCar
White

2
SecondCar_123
Yellow

3
ThirdCar
Red

4
FourthCar_123
White

5
FifthCar
Green

6
SixthCar_123
Blue

id	name	color
1	FirstCar	White
2	SecondCar	Yellow
3	ThirdCar	Red
4	FourthCar	White
5	FifthCar	Green
6	SixthCar	Blue

id	name	color
1	FirstCar	White
2	SecondCar_123	Yellow
3	ThirdCar	Red
4	FourthCar_123	White
5	FifthCar	Green
6	SixthCar_123	Blue