Return to Snippet

Revision: 44403
at April 11, 2011 08:20 by minimalart


Initial Code
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;

Initial URL


Initial Description


Initial Title
Get domain from url

Initial Tags


Initial Language
MySQL