mysql> DELETE * FROM table WHERE something ='FOOBATBAR WAS HERE';
Query OK, 0 rows affected (0.00 sec)