SELECT * FROM table WHERE NAME='Tom'; DELETE FROM table; SELECT * FROM table WHERE NAME='Bob'