Right now, I am using this query to grab all the email domain names from all my users:

SELECT DISTINCT REVERSE(LEFT(REVERSE(email),LOCATE('@',REVERSE(ema il)) - 1)) AS domain FROM users ORDER BY domain


Is there a way to alter this query where it will return 2 columns of data, 1 with the results from above and 1 with count of users with the domain?

Thanks in advance

__________________
one outstanding employee does more and costs less than two adequate performers.

Um, that's what we call obfuscated code. That's really a wacky query, no offense meant. How about:
I'm not particularly good at SQL yet, so I'm not sure how you'd count users per domain. It could be group-by or a subquery as a variable name.

__________________
Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning. - Rich Cook

I'm don't believe there is a way to group things by a part of a value using mysql.

__________________
There are two ways to write bug-free code, only the third one works.

The HAVING clause will allow you to use a value. You can also use variables in MySQL, like so:

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

My version of MySQL (5.0.27) allows me to make the following query without any complaints:

__________________

This is exactly what I wanted. I'm still new to GROUP BY. Thanks alot Salathe!

__________________
one outstanding employee does more and costs less than two adequate performers.