SELECT REVERSE(LEFT(REVERSE(filename),INSTR(REVERSE(filename),'.')))
改进版如下
select RIGHT(filename, INSTR(REVERSE(filename),'.'))
SELECT REVERSE(LEFT(REVERSE(filename),INSTR(REVERSE(filename),'.')))
改进版如下
select RIGHT(filename, INSTR(REVERSE(filename),'.'))
转载于:https://www.cnblogs.com/ganymede/p/3621512.html