DELETE

DELETE FROM table [WHERE condition]

This statement will delete all the rows in a table that match the condition. For more about conditions see SELECT.