From: Rick James
Date: October 12 2012 6:13pm
Subject: RE: Extract text from string
List-Archive: http://lists.mysql.com/mysql/228385
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148D27BE76@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

No.
Or if there is, it is too ugly to contemplate.
You are better off doing such in a real programming language.  MySQL will l=
ocate row(s) containing "this is a test" via LIKE, RLIKE, or FULLTEXT (with=
 caveats).  You need to take over from there.

> -----Original Message-----
> From: Neil Tompkins [mailto:neil.tompkins@stripped]
> Sent: Friday, October 12, 2012 9:56 AM
> To: [MySQL]
> Subject: Extract text from string
>=20
> Hi,
>=20
> Is there such a way in a MySQL query to extract the text "this is a
> test"
> from the following strings as a example
>=20
> <strong><a href=3D"http://www.domain.com/" class=3D"link">this is a
> test</a></strong> <strong><a href=3D"http://www.domain.com/" title=3D"thi=
s
> is a test"
> class=3D"link">link</a></strong>
>=20
> Thanks
> Neil