How to return values from different columns without repeating?

Question

I’m trying to capture and print on the screen all the categories of a table, but I wouldn’t want them to repeat themselves. Note that there are 4 columns of different categories below:

NUMEROID-----NOME-----CATEGORIA1-----CATEGORIA2-----CATEGORIA3-----CATEGORIA4
00001      wordart      Jogos         Saude          Saude         Culinaria
00002      wonderl      Noticias      Noticias       Jogos         Arte
00003      heaveng      Arte          Jogos          Jogos         Jogos
00004      flowwav      Arte          Saude          Jogos         Saude

I would like to print (in php) a list on the screen as in the example below: (If possible in alphabetical order)

• Artistry
• Culinary
• Games
• News
• Health

Thank you all.

Answer 1

A way to solve only in query:

     SELECT CATEGORIA1 AS CATEGORIA FROM NOME_DA_TABLE
     UNION
     SELECT CATEGORIA2 AS CATEGORIA FROM NOME_DA_TABLE
     UNION
     SELECT CATEGORIA3 AS CATEGORIA FROM NOME_DA_TABLE
     UNION
     SELECT CATEGORIA4 AS CATEGORIA FROM NOME_DA_TABLE

O Union irá fazer o trabalho!

http://www.w3schools.com/sql/sql_union.asphttp://www.w3schools.com/sql/sql_union.Asp