MySQL Substring with Last index

Sometimes you may need to use substring in your queries to extract some parts of the values, specially from last index of the value. To achieve that you can use substring_index and reverse functions together.