MySQL query - how to remove variable data
Thanks for your replies.
The examples of text are shown in my original post, but I had to put the "code" formatting around them as the forum would not let me post without doing that. Here are the examples again:

"&gt;https://www.ebay.co.uk/itm/SUZUKI-DR-75 ... Sw7k9eIFHa&lt;/a&gt;&lt;!-- m --&gt;

"&gt;http://www.hagon-shocks.co.uk/catalog/c ... x?TypeID=F&lt;/a&gt;&lt;!-- m --&gt;
"&gt;https://www.moorespeedracing.co.uk/indi ... gKQjPD_BwE&lt;/a&gt;&lt;!-- m --&gt;


I want to remove this whole section of text, but as you can see the centre section (i.e. the www part) varies in each line.
It is MySQL 5.5.65
Sorry, I have no idea how to use "fiddle".