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/";