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