Distinct Count of values, but need a wildcard
If I use this query:
It will give me the count of each occurrence of a distinct value of a field. However, I am wondering if there would be a way to modify this to have a wildcard.
SELECT name,COUNT(*) as count FROM tablename GROUP BY name ORDER BY count DESC;
The background is, I have a field in my table that contains URL's. There are plenty that are in the same domain...ie www.codingforums.com, however, they all contain different points of reference after the .com. More specifically, my question is I want to search for number of occurrences for the domains. They all should begin either http:// or https:// but not all would have the www. and such.
Not sure it is possible but figured I would ask since Google searching didn't really give me anything useful to go off of.