with n(str, ori, pos) as (
values ('AA,BB,CC,DD,', 1, posstr('AA,BB,CC,DD,', ','))
union all
select str, pos+1, locate(',', str, pos+1)
from n
where locate(',', str, pos+1)>0)
select str, ori, pos, substr(str, ori, pos-ori) as result from n order by pos desc fetch first 1 rows only;
//其实我只是要取一个字符串中用','分割的最后一段。。。
values ('AA,BB,CC,DD,', 1, posstr('AA,BB,CC,DD,', ','))
union all
select str, pos+1, locate(',', str, pos+1)
from n
where locate(',', str, pos+1)>0)
select str, ori, pos, substr(str, ori, pos-ori) as result from n order by pos desc fetch first 1 rows only;
//其实我只是要取一个字符串中用','分割的最后一段。。。
7万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
