Extracting information out of a column with regexs in MySQL

Question

Is it possible to get the (first?) match of a regex and output it within a select? It looks like the REGEXP function only return whether there has been a match or not. I want to be able to extract information out of a varchar column without having to use complex SUBSTRING-LOCATION nestings.

Any ideas?

In this similar question http://stackoverflow.com/questions/986826 , @Jeremy Stein suggested using User-defined functions: https://launchpad.net/mysql-udf-regexp — Piskvor left the building, Oct 25 '10 at 13:16

score 0 · Accepted Answer · answered Oct 25 '10 at 12:40

0

http://dev.mysql.com/doc/refman/5.1/en/regexp.html that's all there is. You can't do more than pattern comparison.

answered Oct 25 '10 at 12:40

Alin Purcaru

43,655
12
77
90

Extracting information out of a column with regexs in MySQL

1 Answers1