need SQL help

[guest*]

I imported some products (about 8.000) and choosed the wrong id_category_default, so I need to change on

ps_products all products with id_category default 1

into 1866

which is the correct id-category.

I would be appreciate if somebody can please name a SQL Query for this ? I'm not a coder and don't know SQL-codes.

[rabacik_pl]

UPDATE `ps_product` SET `id_category_default` = 'xxxx';

xxxx is your category number. If it can be done for some records You need add WHERE clause

[guest*]

Sorry I'm really a nooby in that. I want to change only some records (about 8.000 from 22.000), not all records, but all with ID 1. So what should I ammend there ?

something like this ?

WHERE `id_category_default`='1';

[guest*]

I tried this one:

UPDATE `ps_product` SET `id_category_default`=1866 WHERE `id_category_default`=1;

and it worked...

Thxs for your help...

[rabacik_pl]

UPDATE `ps_product` SET `id_category_default` = 'xxxx' WHERE `id_category_default` =1;

I think.
Try before:
SELECT * FROM `ps_product` WHERE `id_category_default`=1
SELECT * FROM `ps_product` WHERE `id_category_default`=1866
??

[guest*]

Thxs. post was overlapped...

Yes the code worked...

The message was strange because 0 rows affected ??? But ok it worked.

Thxs.