tcls188_c2800_x909(2)

WHERE (User_Agent LIKE 'iuc%') OR

(User_Agent LIKE 'juc%') OR

(User_Agent LIKE '%android%') OR

(User_Agent LIKE '%ios%') OR

(User_Agent LIKE '%iphone%')

6589 android,iOS

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE '')

1262 user_agent为空

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent NOT LIKE 'iuc%') AND (User_Agent NOT LIKE 'juc%') AND

(User_Agent NOT LIKE '%android%') AND (User_Agent NOT LIKE '%ios%') AND

(User_Agent NOT LIKE '%iphone%') AND (User_Agent NOT LIKE '')

7048 其他

-----------------------------------------------

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE '%ios%') OR

(User_Agent LIKE '%iphone%') OR

(User_Agent LIKE '%ipad%') OR

(User_Agent LIKE '%ipod%') OR

(User_Agent LIKE '%itouch%')

1147 苹果系列

--------------------------------------------

SELECT *

FROM headerinfo

WHERE (User_Agent LIKE 'iuc%')

725 ucweb 极速

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE '%iphone%')

422

SELECT *

FROM headerinfo

WHERE (User_Agent LIKE 'iuc%') AND (User_Agent LIKE '%iphone%')

0

--------------------------------------------

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE '%android%')

2894 含有android关键字

--------------------------------------------

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE 'juc%')

2557 Android下 ucweb 极速

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE 'juc%') AND (User_Agent LIKE '%android%')

14 由此可见大部分都不含有android

--------------------------------------------

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/shouji/article-29427-2.html