Get domain from url - MySQL Snipplr Social Repository

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