MySQL Question

[nca]

How can I create a mysql query that will look in a table and come back with the most used phrase in a certain cell in the table?
For example, here is my table:

4|Truck|Chevy
5|Car|Honda
6|Car|Toyota
7|Van|Chevy
8|Car|Mitsubishi
9|Truck|Toyota

I want a print out from mysql to be like this:

Car 3
Truck 2
Van 1

Is there any way to have it count up how many of each unique things there are in a cell in a table, and have it decending from the first one being the highest number?

[devinemke]

SELECT make, COUNT(make) FROM table GROUP BY make

where "make" is the field with Truck, Car, Van, etc...

[bradgrafelman]

Nevermind this post...

(Is there no way to delete posts in this forum?)