[ic] Replacing product group

[Ron Phipps]

> From: Philip S. Hempel
> 
> I have about 500 items that need the prod_group changed, I know I
> could replace each by hand but I was wondering if anyone
> has created a script that could replace prod_group = "old_group" to
> prod_group = "new_group" or knows of someway that would be faster
> than doing each item one at a time.
> 
> This would save be a few days worth of work
> 
> Thanks.

If you are running on a sql db you could run the following command in
your database query tool (MysqlAdmin, phpMyAdmin, phpPgsqlAdmin, etc):

UPDATE products
SET prod_group="new_group"
WHERE prod_group="old_group"

See ya,
-Ron