How to update gadget in confluence using sql

[Bhargavi Vasa]

UPDATE BODYCONTENT bc

SET bc.body = REPLACE(bc.body, 'ABC', 'DEF') WHERE contentid = '1234';

Using this SQL ,I have updated the gadget url

In DB it's updated but on UI after doing indexing also it's not reflecting 

[Humashankar VJ]

Hi @Bhargavi Vasa 

Modifying Confluence content directly in the database is strongly discouraged, as it poses a significant risk of introducing inconsistencies or corruption to your instance.

If you have already made database modifications and the changes are not visible in the user interface, it is likely due to caching issues or incorrect indexing, which may be preventing the updates from being properly reflected.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards