find last instance of character in string mysql
snippet in sql

find last instance of character in string mysql

user7080

SELECT SUBSTRING_INDEX("first_middle_last", '_', -1);