select
REVERSE(SUBSTR(REVERSE(‘测试H0938,测试X0644,测试L8199,测试X0275,测试C4477’) FROM INSTR(REVERSE(‘测试H0938,测试X0644,测试L8199,测试X0275,测试C4477’),‘,’)+1))
mysql 截取字符串中某个字符最后出现前所有字符
于 2023-05-19 17:29:35 首次发布
select
REVERSE(SUBSTR(REVERSE(‘测试H0938,测试X0644,测试L8199,测试X0275,测试C4477’) FROM INSTR(REVERSE(‘测试H0938,测试X0644,测试L8199,测试X0275,测试C4477’),‘,’)+1))