From: Neil Tompkins
Date: October 12 2012 4:56pm
Subject: Extract text from string
List-Archive: http://lists.mysql.com/mysql/228382
Message-Id: <CADa_cYp2=YubwRJGW9tLCRTaJAOyaca5Gkf5yja0dSpohkM7qg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b3440f4cf6aef04cbdf9022

--047d7b3440f4cf6aef04cbdf9022
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Is there such a way in a MySQL query to extract the text "this is a test"
from the following strings as a example

<strong><a href="http://www.domain.com/" class="link">this is a
test</a></strong>
<strong><a href="http://www.domain.com/" title="this is a test"
class="link">link</a></strong>

Thanks
Neil

--047d7b3440f4cf6aef04cbdf9022--