How to delete multiple rows in SQL where id = (x to y)

Solution 1:

If you need to delete based on a list, you can use IN:

DELETE FROM your_table
WHERE id IN (value1, value2, ...);

If you need to delete based on the result of a query, you can also use IN:

DELETE FROM your_table
WHERE id IN (select aColumn from ...);

(Notice that the subquery must return only one column)

If you need to delete based on a range of values, either you use BETWEEN or you use inequalities:

DELETE FROM your_table
WHERE id BETWEEN bottom_value AND top_value;

DELETE FROM your_table
WHERE id >= a_value AND id <= another_value;

You can use BETWEEN:

DELETE FROM table
where id between 163 and 265

Please try this:

DELETE FROM `table` WHERE id >=163 and id<= 265