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.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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
