select left(songno,3) as songno from song //截取前3位 select distinct right(left(songno,6),3) as Files from song order by Files asc // 截取中间 select right(songno,6) as 歌曲编号 from song //截取后3位 select left(songno,3) as 服务器编号 from song select mapping from
一.Js中获取地址栏参数 //从地址栏获取想要的参数 function GetQueryString(name) { var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)"); var r = window.location.search.substr(1).match(reg); if (r != null) return unescape(r[2]); return null; } va
--更新 UPDATE wp_order_detail SET layout_type = ( SELECT CASE THEN ) ELSE '' END FROM wp_catalog_size cs WHERE cs.size_code LIKE '%' || wp_order_detail.size_code LIMIT ); --查询 SELECT detail.ID, detail.size_code, ( SELECT cs.size_code FROM wp_catalog_si