If you would like to delete based on a list, you'll use IN
:
DELETE FROM your_table
WHERE id IN (value1, value2, ...);
If you would like to delete based on the results of a query, you'll also useIN
:
DELETE FROM your_table
WHERE id IN (select aColumn from ...);
(Notice that the subquery must return just one column)
If you would like to delete based on a range of values, either you use BETWEEN otherwise, you use inequalities:
DELETE FROM your_table
WHERE id BETWEEN bottom_value AND top_value;
or
DELETE FROM your_table
WHERE id >= a_value AND id <= another_value;
If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.