Is there a command to remove a field from a record under certain conditions?

Question

MySQL

Everything works through phpmyadmin. There is a basis with the table in which it is a lot of records. Each entry has an ID. Up to a certain point, incorrect information was entered in one of the columns, which now interferes. Is it possible to remove it with some command?
For example, table "user_data" of base "example". I need all records that have a "user_ID" field less than 6000 to have the "user_parent" field cleared in the same table.
Tell me please.

Answer 1

UPDATE ... SET ... WHERE