Indeed, I tried this code and it works fine. I agree with you it will prevent possible error. Thank you so much

Ok, I finally found what I needed

UPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'.gif','');

UPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'','');

Thank you!

Thank you for your help,

Actually I tried it on a backup I had.:-D In the process I try to installed, I need to repeat the process in reverse once...

If a need to remove the '.gif' for all the field on the table....

Ok I find it...

UPDATE `categories_images` SET`categories_image`=concat(trim(`categories_image`),'.gif');

Now, I would to know if a need to reverse the process... do you have a idea?

Thanks

I try this but that's not works..

OK , I resolve my error syntax:

UPDATE `categories` SET `parent_id`= 2055 WHERE `sort_order`= 1

Thank you so must 😛

I try this :

UPDATE `categories` SET `parent_id`= 0 [2055] WHERE `sort_order`= 1

the 2055 is the value to try to applie, but I have error syntax... I use the sql...