Inspiration For Creative Minds
Home » Labs » 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
?>
It's only fair to share...Share on Google+Tweet about this on TwitterShare on Facebook
Labs

Posts you may like: