List:General Discussion« Previous MessageNext Message »
From:Rick James Date:October 12 2012 6:13pm
Subject:RE: Extract text from string
View as plain text  
No.
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
> 
> 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