DELETE statement

DELETE FROM table
WHERE search_condition;

Examples

DELETE FROM artists_backup
WHERE artistid = 1;

DELETE FROM artists_backup
WHERE name LIKE '%Santana%';

To remove all rows in the artists_backup table, you just need to omit the WHERE clause as the following statement:

DELETE FROM artists_backup;