How to delete multiple rows in SQL where id x to y

Question

I'm attempting to use a SQL query to remove records from a table with ids 163 to 265. I experimented with this to eliminate less rows.

   DELETE FROM `table` WHERE id IN (264, 265)

But is there a query similar to the one above that can delete hundreds of rows at once? I tried to utilize this type of query as well, but I was unable to do so.

DELETE FROM `table` WHERE id IN (SELECT * FROM table WHERE id = )

Please tell me the query to do the above action.

Answer 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;

or

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