To update a specific column in a table we must need an identity with where clause and we can set specific column value according to the below statement.
update table_name set column_name = new_value where identity_column_name = value
where -
column_name is the name of a specific column whose value you want to update.
identity_column_name is the name of a column in the same row which works as an identity for example id, phone, email etc.