Skip to content

Instantly share code, notes, and snippets.

@aliaspooryorik

aliaspooryorik/listLast.sql

Created March 26, 2019 15:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aliaspooryorik/fd15f2b8385fc065e6d182f3d01eaf19 to your computer and use it in GitHub Desktop.
Save aliaspooryorik/fd15f2b8385fc065e6d182f3d01eaf19 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL get last element from delimited list
Raw
listLast.sql
SELECT SUBSTRING_INDEX('1/2/3/4/500', '/', -1) AS last_element;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment