Delete records within a specific Range from MySQL table
If you want to delete a range of records from MySQL table then you can use following query. Below example will delete records within the ID 1000 and 5000.
<?php delete from table_name where ID between 1000 and 5000 ?>
or you can use below query for the same.
<?php delete from table_name where id >= 1000 and id <= 5000 ?>