If I use this query:
SELECT name,COUNT(*) as count FROM tablename GROUP BY name ORDER BY count DESC;
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.
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.