SELECT a1,a2,replace(a2, “豫ICP备16006180号-“, “”) a22,a3,a4,a5 FROM `aaab` order by a2;
SELECT a1,a2,substring(a2, 22) a22,a3,a4,a5 FROM `aaab` order by a22;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/119292.html原文链接:https://javaforall.net
mysql replace substring 字符串截取处理
SELECT a1,a2,replace(a2, “豫ICP备16006180号-“, “”) a22,a3,a4,a5 FROM `aaab` order by a2;
SELECT a1,a2,substring(a2, 22) a22,a3,a4,a5 FROM `aaab` order by a22;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/119292.html原文链接:https://javaforall.net