DELETE FROM table_name WHERE column_name = some_value

Delete All Rows:

DELETE FROM table_name or DELETE * FROM table_name