mysql query question

I have a query something like this:

select * from stuff

I want to select rows where each name is distinct like:

select distinct name from stuff

The first query gives me all columns, but includes the duplicate names.
The second query gives me the name column with no duplicates. How can I
combine the two, so I get all columns, but without duplicate names?

Thanks

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss