CODE EXAMPLE FOR SQL

mysql return text after a final full stop

SELECT SUBSTRING_INDEX("here.is.some.txt", '.', -1);