I have a column called 'url' in 'table' whose records are in the pattern 'http://example.com/value/372954412/'.
I want to update these to 'https://www.example.com/value/372954412/'. The size of the table is huge. How do I go about this?
The function to replace a string with another is REPLACE:
set url = replace(url, 'http://', 'https://www.');