samedi 16 septembre 2023

Select with random ORDER in MySQL Within 1 row

I Have this Level 1 table enter image description here I want to make query, when the query is execute the order of J1,J2.. J5 is in random order

I have this query

SELECT j1,j2,j3,j4,j5 FROM `level_1` ORDER BY RAND()

but it only randomize the index row, not the inside image result

I want to make this result with random column order, but cant figure it out yet I hope this result




Aucun commentaire:

Enregistrer un commentaire