A QR code is just a visual encoding of text — there's no database lookup or network call involved in reading one. A phone camera decodes the pattern back into the exact string you started with, whether that's a URL, a WiFi network's SSID and password, a vCard's contact fields, or plain text. That also means a QR code pointing at a URL is only as reliable as that URL — if the destination page moves or the site goes down, the code still "works" in that it decodes correctly, it just leads somewhere broken.
If you expect a destination to change over time, encode a URL you control and can redirect, rather than baking in a link that might not last.