SQL Select update http url

update_http_url.sql

#
# This should update the url to NEW_IP and NEW_PORT  ( UNTESTED )
#
DEFINE NEW_IP   = '10.10.10.10'
DEFINE NEW_PORT = '443'
UPDATE DB_NAME.TABLE_NAME 
SET field_name=REGEXP_REPLACE(field_name, '(http?://)(.*):(.*)/(.*)', '\1&NEW_IP:&NEW_PORT/\4')
WHERE field_name LIKE 'http%'
AND field_name NOT LIKE '%uri/path%'