62,040
社区成员
发帖
与我相关
我的任务
分享
select left(talk_source,LEN(Talk_source)-CHARINDEX('?',REVERSE(Talk_source))) as Talk_source2,*
from Zoosnet_Data
where Project_ID=1 and (Zoosnet_Visit_Start_Time between '2013-1-1' and '2013-8-1')
and Zoosnet_Data.Talk_Source like '%http://www.baidu.com/abc.html?eee%'
var pos = url.IndexOf('?');
if(pos<0)
pos = url.IndexOf('#');
........
if(url.EndWith("/"))
........
这样的处理就非常好。