select column names in mysql

[Archbob]

lets say I have 9 mySQL entries in database but the category field of each entry has either bob or joe. How do I make a query state that return just the two words bob and joe in an array?

Thanks in advance.

[leatherback]

select distinct category from table

http://www.mysql.com/doc/en/SELECT.html