有一些网址,例如:
http://127.0.0.1:8080/site/Index/index.html
http://anhui.zxxk.com//Soft//Default.html
http://anhui.zxxk.com/Soft/Default.html
http://bbs.8da.com/thread-1454833-1-1.html
http://bbs.saraba1st.com/2b/thread-1101463-1-1.html
http://bbs.zxxk.com/dsu_paulsign-sign.html
http://bbs.zxxk.com/forum-108-1.html
http://bbs.zxxk.com/thread-51023-1-1.html
http://bbs.zxxk.com/thread-835-2040-1.html
http://beijing.zxxk.com//Soft/123548.html
http://beijing.zxxk.com/Article/148662.html
http://beijing.zxxk.com/Article/Class/4526.html
http://beijing.zxxk.com/Soft/Default.html
http://beike.zxxk.com//j-0-0-0-0-0--0-1-0-0-0--20-0-0-0-0-0---0-p1.html
http://beike.zxxk.com//s2359305.html
http://beike.zxxk.com//s2529221.html
http://beike.zxxk.com//s3905126.html
http://beike.zxxk.com//s3932853.html
http://beike.zxxk.com//s-channel-11-.html
标黄的是我想要的,里面还有关键字,比如同时包含/s zxxk .html 不能包含index default -等,我写了个语句,怎么不行呢
update 访问明细 set 网址分类='下载详情页' where 轨迹1 like '%zxxk%' and 轨迹1 like '%/s%' and 轨迹1 like '%.html' and 轨迹1 not like
'%index%' and 轨迹1 not like'%default%' and 轨迹1 not like'%-%'
------解决思路----------------------
我用你代码测试是OK的,检查当前DB是否设置大小写字符敏感
------解决思路----------------------
可以在这里查看当前库的设置:
可以和这篇博客一起看看:
http://www.cnblogs.com/dragonwlb/archive/2012/04/20/2459549.html