MySQL extract substring using regular expression

Question

My SQL request:

SELECT Path FROM Media m join Article_Image am on m.id=am.mediaid where am.articleid=609;

The value in the Path column:

/uploads/dddef9788caab36fcfd0ce05c84373e3.jpeg

I need to extract dddef9788caab36fcfd0ce05c84373e3 using regular expression.

Tim Biegeleisen · Accepted Answer · 2018-06-21 01:19:06Z

1

MySQL does not have any native regex extraction support. But we can use SUBSTRING_INDEX instead:

SELECT
    SUBSTRING_INDEX(SUBSTRING_INDEX(PATH, '/', -1), '.', 1)
FROM yourTable;

Demo

answered Jun 21, 2018 at 1:19

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

I need to wait 8 minutes