Posted By

minimalart on 04/11/11

Tagged

Viewed 791 times

Favorited by 0 user(s)

/ Published in: MySQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT
SUBSTR(FIELD, 1 , LOCATE('/', FIELD, 8)-1)AS Domain, COUNT(1) AS Count
FROM TABLE
GROUP BY Domain
ORDER BY Count DESC LIMIT 250;

Comment:

You need to login to post a comment.