How to update data by sql update query?


I am trying to update one field in a table( eg:object_query_12 & object_store_12 ) which has updated that one field by running update sql query in those tables. But in the pimcore admin it is not reflected.

Do i need to update anywhere else too or sql update is possible or not!

Can someone please give me some solution.

Thank you.

possibly you need to clear the cache too.
But in general - don’t do SQL updates directly on database, always use the APIs.