Date: 04/13/07 (MySQL Communtiy)    Keywords: mysql, sql

Hello all,

I'm trying to delete a range of rows in MySQL and coming up broke.

On my command line, I'm doing the following:

mysql> delete from table where table.id in (11700)

Or

mysql> DELETE FROM `table` WHERE `table`.`id` = 11700;

That's great, but, I'll still have 10,000+ more rows to go, and both methods require me to delete rows one by one. I'd rather just delete a range of rows.

I want to only delete rows from 300-11800.Does anyone know how to delete a certain range of rows? Or just tell MySQL to delete a certain range of rows?

Thanks!

Source: http://community.livejournal.com/mysql/112993.html