Skip to content

Instantly share code, notes, and snippets.

@jonpemby

jonpemby/substr_last.sql

Created March 1, 2018 17:16
Show Gist options
  • Save jonpemby/31ad70aef3c5eb3c6a2e26bebd91d5c1 to your computer and use it in GitHub Desktop.
Save jonpemby/31ad70aef3c5eb3c6a2e26bebd91d5c1 to your computer and use it in GitHub Desktop.
Download ZIP
Find last part of a string after delimiter in SQL
Raw
substr_last.sql
SELECT SUBSTRING_INDEX("first_middle_last", '_', -1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment