Counting up entries in a table

[nca]

Here is a sample mysql table layout:

1|data1
2|data4
3|data1
4|data7
5|data7
6|data1
7|data9

---

I want to count up how many times a
data entry is shown in a certain column
in the table. To output something like this:

3 - data1
2 - data7
1 - data4
1 - data9

Anyone have any ideas how I can make a query to give me this kind of output?

[tomhath]

Use a "group by" with the count function:

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html