tcls188_c2800_x909(3)

SELECT COUNT(*) AS Expr1

FROM headerinfo

WHERE (User_Agent LIKE 'iuc%') OR

(User_Agent LIKE 'juc%')

3282

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

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

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 LIKE '%nokia%' or user_agent like '%SymbianOS%')

3095 nokia,sysbianOS

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

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 '%nokia%') AND

(User_Agent LIKE '%maui%')

327 mtk山寨机

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

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 '%nokia%') AND

(User_Agent NOT LIKE '%maui%') AND (User_Agent LIKE '%j2me%')

1264 java最早的按键手机

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

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 '%nokia%') AND

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