[ic] Simple MySQL query.

[Ron Phipps]

Yes :)

UPDATE products
SET category = 'seac-sub masks'
WHERE category = 'seac-sub mask'

UPDATE products
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.

See ya,
-Ron

----- Original Message -----
From: "Thomas N. Stefanidis" <thomas@prometheas.gr>
To: "Interchange Mailing List" <interchange-users@lists.akopia.com>
Sent: Tuesday, February 27, 2001 11:04 AM
Subject: [ic] Simple MySQL query.


> Hello,
> 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
>
> Thomas
>
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users