Ok, I'm a little rusty with MySQL. Let's say I want to show all my data in a database column but I want to only show it once.

Example:
Code:
ZIP       ADDRESS
12345       Smith St.
12345       Oak St.
14445       Marble Ave.
If I do a SELECT * FROM table, I will get 12345, 12345, and 14445. However, I just want it to report 12345 once. How do I do that?

Thanks.