Displaying Data from Database

[.Darkman]

Hello Everybody,

 

I know the basics of displaying data from mysql database. Now i need some advanced help.

 

Let me explain with an example:

 

I have 4 rows and 1 column in my table.

 

1st row : "rat, cat, elephant"

2nd row : "cat, lion, tiger"

3rd row : "elephant, rat, lion"

4th row : "cat, tiger, bear"

 

I have these data. (i.e) few words separated by comma. Some words repeat.

 

Now i want to display information from this table as :

rat

cat

elephant

lion

tiger

bear

 

(i.e) I want to display all the names but without repetition. How do i do it ?

 

Please Help.

 

 

 

Thanks,