mysql display problem

[smatts9]

I have a table with a bunch of junk in it, and one of the columns is 'city', and for instance I go to list all of the available cities in a state where the item is, state is also a column, and it will go down the database and list every city it sees. So I see a lot of Baltimore's listed.

How do I limit to only listing it once?

[dreamcatcher]

Hi smatts9,

I think you may be looking for the DISTINCT clause?

SELECT DISTINCT(city) FROM table...

or maybe the WHERE clause?

SELECT FROM table WHERE city = ''..

dc

[smatts9]

Thank you, the DISCTINT is exactly what I needed.

[inveni0]

You can also use GROUP BY `city` WHERE `State` = "Ohio"