MySQL: Delete Rows

DELETE FROM table WHERE field="value";

To delete all rows:

DELETE FROM table;