Is there basename() equivalent in MySQL?

Ugur
Ugur
Jul 23, 2017 · 1 min read

Found on stackoverflow.com

You can use the SUBSTRING_INDEX function to get the last element after a specific delimiter, in this case a slash. This can also be used with a backslash, simply use "\\" in that case.


Originally published at search hacker.

Ugur
Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade