Delete SQL Query

Delete SQL Query

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';