REGEXP_SUBSTR
REGEXP\_SUBSTR(expr, pat[, pos[, occurrence[, match\_type]]])
#Examples
mysql> SELECT REGEXP_SUBSTR('abc def ghi', '[a-z]+');
abc
mysql> SELECT REGEXP_SUBSTR('abc def ghi', '[a-z]+', 1, 3);
ghi
Comments
REGEXP\_SUBSTR(expr, pat[, pos[, occurrence[, match\_type]]])
mysql> SELECT REGEXP_SUBSTR('abc def ghi', '[a-z]+');
abc
mysql> SELECT REGEXP_SUBSTR('abc def ghi', '[a-z]+', 1, 3);
ghi