重新排列表格行

Question

I want to rearrange mysql table rows for example

column1 | column2 | column3
1         abc       abc
2         def       def
3         ghi       ghi

after some procedure

column1 | column2 | column3
2         def       def
1         abc       abc
3         ghi       ghi

means randomly rearrange existing table

NOTE: I cant use rand() in mysql query for some reason

Answer 1

Try like this:-

SELECT * FROM tableName ORDER BY RAND();