mysql get string after last occurrence of string code example
Example: find last instance of character in string mysql
SELECT SUBSTRING_INDEX("first_middle_last", '_', -1);
SELECT SUBSTRING_INDEX("first_middle_last", '_', -1);