SELECT substr('xxxx-1111-xxxx-xxxx',instr('xxxx-1111-xxxx-xxxx','-',1)+1,(instr('xxxx-1111-xxxx-xxxx','-',2)-(instr('xxxx-1111-xxxx-xxxx','-',1)+1) ) FROM dual
sql写法
left(replace(RECIPENAME,'6inch-',''),locate('-',RECIPENAME)-1)