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