replace/update the item in the database

[Xtremist]

Hii guyz,

Suppose I want to do like,

whoever has a knife on my server.... I want to give them a katar instead of knife.

I want to do it in SQL,

how will the query be?

update ...... set nameid=katar where nameid=knife?

Can i get a proper query? which will include all the tables where it may occur?

Thank you.