MySQL中最右边出现的字符串匹配

I would like to extract the file extension from a field in MySQL that contains filenames. This means I need to find the final '.' character in the field and extract everything after that. The following code example partially works:I would like to extract the file extension from