[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Simple MySQL query.
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
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
