Deleting Mulitple Entries

Hello,

I'm pretty new at MySQL so any help would be appreciated URL

OK..
To delete from a table I use this:

mysql> DELETE FROM table
-> WHERE (uid = "1");

Now lets say I wanted to delete from uid = 1 till uid = 100. How would I do that?

Thanks for your time!

For this particular query you could use:

delete from table where uid<101;

if you want to delete in the middle:

delete from table where uid between 1 and 100;

Note: with between the delimiters are inclusive.