How to update the content of one column in Mysql by another column name?

UPDATE egg.eggs_record 
SET sold = '2024-11-21'
WHERE id = 3 
	OR id = 4;


UPDATE egg.eggs_record 
SET egg_name = 'duck egg'
WHERE id = 2;