advice limiting query between ..

[rayzun]

How is it possible to limit a query to a designated number of records.
not sure if Im wording this correctly..

My table has the first field to "id" it is a INT, primary & is auto increment

query only to say
id = 655 to 2222 range ?
where 'name' LIKE 'jugs'

[Sxooter]

select * from sometable where name like '%jugs%' and id between 655 and 2222

OR

select * from sometable where name like '%jugs%' and id >= 655 and id <= 2222

[rayzun]

thanks alot Sxooter