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
boom!
http://dev.mysql.com/doc/refman/5.1/en/adding-udf.html

S



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="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
>

Thread
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