Delete SQL Query

Question

I want to delete rows of a column on the basis of condition of another column. For example:

DELETE FROM table_name column_name WHERE another_column_name='some value';

Answer 1

If you mean "delete the column", you can set it to null:

UPDATE table_name SET
column_name = null
WHERE another_column_name = 'some value'