title: Select count / duplicates
body: <p>I have a table with all U.S. zip codes. each row contains the city and state name for the zip code. I'm trying to get a list of cities that show up in multiple states. This wouldn't be a problem if there weren't X amount of zip codes in the same city... </p>
  
  <p>So basically, I just want to the city in a state to count as 1 instead of it counting the city/state 7 times because there are 2+ zip codes in that city/state...</p>
  
  <p>I'm not really sure how to do this. I know I need to use count but how do I tell the mysql to only count a given city/state combo as 1?</p>