Hide MySQL count column

Question

When you use count and group by in mysql, how do I hide the count column that implicitly shows up in the resulting table?

SELECT name, region, COUNT(*) as num_visits 
  FROM world
    GROUP BY region
      HAVING num_visits > 1

This will display a table with one column as the region and the other as the num_visits to each (given that it was visited more than once).

Is it possible to hide that last column so that only the regions are shown?

Thanks!

score 10 · Accepted Answer · answered Jan 28 '14 at 05:39

10

use the calculated column instead,

SELECT region
FROM   world
GROUP  BY region
HAVING COUNT(*) > 1

answered Jan 28 '14 at 05:39

John Woo

1

Ah okay so it counts at the end when it is already grouped rather than the start? – user1530318 Jan 28 '14 at 05:49
[SQL Query Order of Operations](http://www.bennadel.com/blog/70-SQL-Query-Order-of-Operations.htm) – John Woo Jan 28 '14 at 05:53

1 Answers1