Or if there is, it is too ugly to contemplate.
You are better off doing such in a real programming language. MySQL will locate 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
> Is there such a way in a MySQL query to extract the text "this is a
> 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/"
> is a test"