Home » Labs » Delete records within a specific Range from MySQL table  

Delete records within a specific Range from MySQL table


Filed under Labs

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
?>

Posts you may like: