How to display the sum of data from a myqsl row?

[Louneworld]

Hello,

This is killing me.

Im trying to SELECT how many times a certain data is posted on my database.

Example: How many times the word "NYC" was submitted.

So the SELECT should display:
NYC - 15
Meaning the word "NYC" is posted in row "city" 15 times.

How can I SELECT such a query?

Thank you soo much.

[mwasif]

Use COUNT with GROUP BY

[code=mysql]SELECT city, COUNT(*) FROM table_name
WHERE city = 'NYC'
GROUP BY city[/code]

[kovik]

In order to use this with a third-party application (i.e. PHP), you'll want to give the COUNT(*) an alias.

SELECT `city`, COUNT(*) as `total` FROM ...