for simplicity lets say it has only 1 field. ID. 

In MySQL, i want to list all the IDs just once (and in order) in the first column of the result, but in 2nd, 3rd and 4th columns i want to display random IDs from the same table - all 4 IDs need to be different in each row. 

I'll explain visually. eg table with 5 rows:

ID:

A

B

C

D

E

RESULT should look something like this:

A B D C

B C E D

C A D B

D E C B

E A C B

I'm very new to MySQL - although have plenty experience with other SQLs. I've tried to use RAND() and LIMIT and i get incorrect results - either column 1 has duplicates or columns 2,3 & 4 returned only one result all the way down.

help - please 

=)