现在有一条sql语句select ID as id,Name as name,IP as ip,lat,lon,0 as type from trk.devs_v2 where type=0 union all select id,signalName as name,ip
,lat,lng as lon,99 as type from yc_signal.signal union all想使用正则让最后一个union all去掉 而不是去掉所有的union all想要的结果为select ID as id,Name as name,IP as ip,lat,lon,0 as type from trk.devs_v2 where type=0 union all select id,signalName as name,ip,lat,lng as lon,99 as type from yc_signal.signal有正则大神帮帮忙呗! 万分感谢
1 回答

幕布斯6054654
TA贡献1876条经验 获得超7个赞
let str = "union albdfdfdfunion alaadunion al";
let reg = str.replace(/(union al)$/,'');
console.log(reg)
添加回答
举报
0/150
提交
取消