[ic] Replacing product group

[Mike Heins]

Quoting cfm@maine.com (cfm@maine.com):
> On Tue, Aug 20, 2002 at 11:41:57PM -0400, Philip S. Hempel wrote:
> > 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
> 
> php would be faster.
> 
> Now just where did I put those thumbscrews?

yoursql> update products set prod_group = 'new_group'
      -> where prod_group = 'old_group';
500 record(s) updated.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Nature, to be commanded, must be obeyed. -- Francis Bacon