I want to update a range of products within a MySql database using phpMyAdmin

The SQL Query I'm using is:

UPDATE `products` SET `manufacturers_id` = '1' WHERE `products`.`products_id` = 3 LIMIT 1;


What I'd like to do is place a range in place of '3' in 'products.products_id'=

So that I can update a range of ID's at once instead of doing them all individually. Can someone please show me how?
Thanks

One solution is to use the IN operator and provide a comma separated list of the record you wish to update:

Code:

UPDATE TABLE SET FIELD1='value' WHERE FIELD2 IN (comma,separated,list,of,values)

Thanks Shaggy, worked a treat :)

You're welcome, Webbo