Need help for a SQL request

Hello

if you want to consider both main and secondary categories
then yes
you will need to use PPP__flexicontent_cats_item_relations table
see the modified query below

Thank again, ggppdk, it seems I see the problem (but I'm unable to know why).

This request return 0 line too, so nothing happen.
Field 602 remains empty for items in category 56.

But if I edit an item and set a value in field 602 manually (a value other than 'Générique', like 'toto') and execute your request, 'toto' is well replaced by 'Générique'.
So it seems this request work only for items that have already a value in field 602, and a value different than those in the request.
But if field 602 is empty for items we want to modify, the request don't work.

Thank you for helping me to solve this problem

It seems it's because UPDATE affect only existing lines on the table.
Because lines doesn't exist (field 602 has no value yet, and it is empty) the request won't work.

So maybe the UPDATE command have to be replaced by another SQL command ? Like INSERT INTO ?

Hello,
Do you have any solution please to replace the request UPDATE by INSERT INTO ?
Thank in advance.

Hello

the query that i gave you is for replacing existing values
because that is what i understood from your original request

The insert will use a SELECT for values

something like: (i have not tested it)

Many thanks ggppdk, it works now

You just invert some fields (field_id and item_id), so correct request is as follow :

And because I have no use of type, I can just use these request :
Now, I have just to replace category_id and value and I can edit all my items at once.

Thank you very much.