Is there a mysql query that does this?

[no_maam]

how can i do a mysql query that returns only results found more than a number of times ?
Lets say i have a table with registered users and i want to display the top x locations by number of users.
E.g. :

Top countrys : Uk(200 members), France(85 members), ...
Thanks!

[bladx]

You can use a query like this:

select * from (table name here) where (ex: population row) > (some number... ex: 50);

example of how it could look:

select * from countries where population > 50;

[Sorce]

Try this:

SELECT country, COUNT(*) FROM table GROUP BY country;

[nemonoman]

You can also restrict a GROUP BY query with a HAVING clause, which acts a lot like a where clause

SELECT country, COUNT()
FROM table
GROUP BY country
HAVING COUNT() > 100

Only countries having more than 100 rows would be returned.

This syntax can be used with a WHERE clause also.

SELECT country, COUNT()
FROM table
WHERE country LIKE 'UNITED%'
GROUP BY country
HAVING COUNT() > 100

Would return UNITED KINGDOM, UNITED STATES, etc., if the number of rows was more than 100

[no_maam]

thanks guys! I'll try your code.