extract value using regular expression in mysql

Question

I am storing values in database like this

www/content/lessons/40/Digital Library/document1.doc

I need to extract the file document.doc.

How to retrieve this value from mysql using regular expression.

Haim Evgi · Accepted Answer · 2010-01-18 09:27:38Z

6

you not need to use regexp (low performence) use substring_index instead

SELECT SUBSTRING_INDEX('bbb/bbbbbb/bbbbbbbbb/bbbb', '/', -1);

link :

answered Jan 18, 2010 at 9:13

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mc0e · Accepted Answer · 2013-08-19 07:01:34Z

0

Mysql does not provide regex based extraction from strings, but you can extend mysql to do this:

It's not a good solution for a lot of people though. eg you couldn't use it in a shared hosting environment.

answered Aug 19, 2013 at 7:01

mc0e

2,88031 silver badges25 bronze badges