[ic] Simple MySQL query.
Tue, 27 Feb 2001 12:18:27 -0800
SET category = 'seac-sub masks'
WHERE category = 'seac-sub mask'
SET category = 'mares masks'
WHERE category = 'mares mask'
Modify the category table to have these modified categories, run the queries
against your products table and you should be good to go.
----- Original Message -----
From: "Thomas N. Stefanidis" <firstname.lastname@example.org>
To: "Interchange Mailing List" <email@example.com>
Sent: Tuesday, February 27, 2001 11:04 AM
Subject: [ic] Simple MySQL query.
> I have some products (they are all in the same category) and i want to
> change the category name
> old : mares mask
> old : seac-sub mask
> change to : mares masks
> change to :seac-sub masks
> is there an easy way to do with an MySQL query?
> Thank you
> Interchange-users mailing list