How to change Magento 2 web address directly in database

If you moved your store to a new domain or created a copy of the site in a new location and can't access the site, because it keeps redirecting to your old address, you need to change Magento host.

This can be done using the following query:

update `core_config_data` set `value`="https://www.NEWDOMAIN.com/" WHERE value= "https://www.OLDDOMAIN.com/";