List:General Discussion« Previous MessageNext Message »
From:Singer Wang Date:October 12 2012 7:19pm
Subject:Re: Extract text from string
View as plain text  
Of course...

There's many libraries for REGEX which you can use, link it with an UDF and


On Fri, Oct 12, 2012 at 12:56 PM, Neil Tompkins <
neil.tompkins@stripped> wrote:

> 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="" class="link">this is a
> test</a></strong>
> <strong><a href="" title="this is a test"
> class="link">link</a></strong>
> Thanks
> Neil

Extract text from stringNeil Tompkins12 Oct
  • RE: Extract text from stringRick James12 Oct
  • Re: Extract text from stringSinger Wang12 Oct
  • Re: Extract text from stringhsv13 Oct