Selected from Linux Selected from PHP
- Ubuntu 17.10 Install google's mod pagespeed for apache - PHP-Ubuntu-Youtube-dl simple script for converting and downloading youtube video or mp3
- Ubuntu SSH tunnel via proxy - PHP while loop with every row with a different color
- Install GoAccess Apache Log Analyzer Tool on Ubuntu 17.10 - PHP use while loop in function
- SSHFS and map folder with a proxy - PHP List Files And Folders As links
- How to connect to SSH server with a proxy - PHP Extract Text From String
➥ SELECT browser, as COUNT
Added by sonik on 02-05-2017 and keywords: Mysql, select, count, база, данни [ Print Article ]
SELECT browser, COUNT(browser) AS freq FROM
(SELECT
CASE
  WHEN useragent LIKE '%Chrome%' THEN 'Chrome'
  WHEN useragent LIKE '%Safari%' THEN 'Safari'
  WHEN useragent LIKE '%Firefox%' THEN 'Firefox'
  WHEN useragent LIKE '%MSIE 7%' THEN 'IE7'
  WHEN useragent LIKE '%MSIE 8%' THEN 'IE8'
  WHEN useragent LIKE '%MSIE 9%' THEN 'IE9'
  WHEN useragent LIKE '%MSIE 10%' THEN 'IE10'
  WHEN useragent LIKE '%rv:11%' THEN 'IE11'
  ELSE 'Other'
 END browser
 FROM loginhistory) AS browsers
GROUP BY browser
ORDER BY freq DESC

@All rights reserved with Copyright Webleit.info 2018 by Sonik_Blast [ Site Map ] [ RSS ] [ YouTube Mp3 Downloader and converter ]