SELECT REVERSE(LEFT(REVERSE(filename),INSTR(REVERSE(filename),'.')))
改进版如下
select RIGHT(filename, INSTR(REVERSE(filename),'.'))
ganymede 2014-03-24 18:10 原文
SELECT REVERSE(LEFT(REVERSE(filename),INSTR(REVERSE(filename),'.')))
改进版如下
select RIGHT(filename, INSTR(REVERSE(filename),'.'))