I'm using a MySQL database, and I was wondering, Is there a way to use Select * from a table and not receive duplicates.

Duplicates as in:

row[0] = 'john';
row[1] = 'doe';
row['first'] = 'john';
row['last] = 'doe'
Or is there atleast an easy way to get rid of the duplicates without having to do it one by one?