How to update the content of one column in Mysql

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;