delete range value something like where ID = 140 to 2800

can i del where ID=100 to 2800  to remove 2700 rows?

Tia
LVL 7
5thcavAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
bobbit31Connect With a Mentor Commented:
Hello 5thcav,

not sure i understand you but can't you just do:

delete from your_table where id >= 100 AND id <= 2800

Regards,

bobbit31
0
 
5thcavAuthor Commented:
that maybe it.. i'll c having a brain phart
0
 
toddbehnkeConnect With a Mentor Commented:
delete from table where id BETWEEN 100 and 2800
0
 
vs1784Connect With a Mentor Commented:
DELETE FROM your_table WHERE ID BETWEEN 100 AND 2800
0
 
5thcavAuthor Commented:
Thanks...
first 1 wins... btw would between remove 100 and 2800 and only del 101 to 1799 i'll try someday... thanks... i only needed this one time.. like i said was having a brain fart...
0
All Courses

From novice to tech pro — start learning today.