find Url among text and erase it in mysql database
<p>What I need to do is:</p>

<ol>
<li>Find the url text inside long text field.</li>
<li>Cut the url from the text.</li>
<li>Update the text field with the new value.</li>
</ol>

<p>So far I can find the Url inside long text with the following code: </p>

<pre><code>SELECT colomname FROM tablename
 WHERE colomname REGEXP "(https?:\/\/|www\.)[\.A-Za-z0-9\-]+\.[a-zA-Z]{2,4}"
</code></pre>