The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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
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
Posted
One solution is to use the IN operator and provide a comma separated list of the record you wish to update:
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Code:
UPDATE TABLE SET FIELD1='value' WHERE FIELD2 IN (comma,separated,list,of,values)fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Posted
Thanks Shaggy, worked a treat :)
