mysql取文件扩展名

SELECT REVERSE(LEFT(REVERSE(filename),INSTR(REVERSE(filename),'.')))

改进版如下

select RIGHT(filename, INSTR(REVERSE(filename),'.'))