用于随机化帖子的SQL [重复]

Question

This question already has an answer here:

• How to request a random row in SQL? 28 answers

In my SQL i have a table with a column id & Order.On website data is displayed according to id & Order.But we want to change the way data is displayed we want to randomize whole content..Can anyone please suggest SQL query for this.

rough database structure is below

city_id       city_name       city_order
  1               xyz             1
  2               geh             2
  3               tre             3

Regards,

</div>

Answer 1

You would do something like this:

select city_id, city_name, city_order from table_name order by rand()

where table_name is the name of your table