SQL

find last instance of character in string mysql

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

mysql get last character of string

select right(columnname,1) as TEST from Testtable;