About mysql (question is easy) Please stop by

There is a point of blockage while working with mysql. Our company's DB status is...

There are dozens of the same data in a field in the table.

What I want to do is to specify and update only one data in a field that contains dozens of duplicate data in one field in one table

If you look at other posts,

UPDATE Table Name

SET Field Name = Data Value

WHERE field name = data value

In this way, I update it when the conditions are established, but in my case, regardless of the conditions, it is duplicated

There are dozens of data, so if you write it like that, the dozens are updated;

I don't know how.I think I'm saving the poor beginner

Help me, masters.