Select from MySQL

[dprevite]

In my database I have a list of reports. There is a field called 'Company Name'. There are over 8,000 entries and some companies are listed many times. I need a way to select the company names without any duplicates. Anyone have any ideas?

[leatherback]

Hi,

Use distinct:

select distinct compagny from database

J.

[dprevite]

Wow, that was easier than I expected. Thanks!