DELETE FROM table_name WHERE condition;
DELETE FROM table_name;
-- Deletes all records where `columnName` matches the values in brackets. DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');
delete from yourTableName where yourColumnName NOT IN(‘yourValue1’,‘yourValue2’,‘yourValue3’,.........N);