How to make multiple field instances show only once

in mysql

[Vastio]

Thanks for reading...

If I have a database that's ordered like this:

Joe
Bob
Suzy
Bob
Bob
Suzy

How can I query it so it shows only:

Bob
Joe
Suzy

Thanks!

[txbakers]

select DISTINCT name from table