MySQL Query to Find/Replace all WWW. instances

Hi all…

I’d like to do a query to remove all instances where https://www.mywebsite.com is located and replace it with mywebsite.com – removing the www. Could anyone help me on this?

I did a search and there’s just too many to go one by one and I found some tables have a lot of extra things surrounded by the https://www.mywebsite.com. So I don’t want it to replace the entire cell but only the text inside the cell that contains https://www.mywebsite.com

Makes sense?

Thanks!