Need Help in mysql Update query

Hello,
I want to update all posts in wordpress database.
i want to change an id that is inserted in every post in my wordpress website.
how can i change all with update query ?

for example, if i have following line in all my posts
"the id is id-000 and the password is pass-000"

and i want to change id-000 to id-111, what should be the query ??

 

Finally found out myself
UPDATE wp_posts
SET post_content = REPLACE(`post_content`,'id-000','id-111');