Update queries are very useful for a lot of things like changing to https.
https://www.ubbcentral.com/forums/u...transition-your-forum-from-http-to-https

Or maybe you totally changed the paths due to moving the site from a sub folder to the root.
Where paths may break for such as links to other posts in the forum.
Or you decide to move or rename the folders for attachments and or avatars.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers