OK... I have a database where I enter stats about who's viewing my site (Country, Browser Type, etc), and one of these fields is the Referring URL. I'm making a query that gives me a count of how many visitors I get from different URLS. I'll use google for this example.
My query is:
SELECT COUNT(RefURL) AS ReferCount, RefURL
WHERE (RefURL <> '')
GROUP BY RefURL
This works great, except for one thing... it sees http://google.com and http://www.google.com as different sites... is there anyways I can parse the RefURL strings and just compare them on the domain?
Thanks in advance