Re: Extract text from string

2012-10-13 Thread hsv
2012/10/12 17:56 +0100, Neil Tompkins Is there such a way in a MySQL query to extract the text "this is a test" from the following strings as a example http://www.domain.com/"; class="link">this is a test http://www.domain.com/"; title="this is a test" class="link">link Amongst

Re: Extract text from string

2012-10-12 Thread Singer Wang
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.tompk...@googlemail.com> wrote: > Hi, > > Is there such a way in a MySQL query to extr

RE: Extract text from string

2012-10-12 Thread Rick James
> From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > 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 str

Extract text from string

2012-10-12 Thread Neil Tompkins
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 http://www.domain.com/"; class="link">this is a test http://www.domain.com/"; title="this is a test" class="link">link Thanks Neil