Randomise IDs in Mysql

Chronicle · 30 Dec 2006 at 14:47

Hello,
I have a database, but i want to reorder it so they're all random.
Is there an easy to way to do this?
I can't just set it so that the id becomes a new id (as there will be duplications).

Chronicle · 30 Dec 2006 at 16:47

I display them like as news posts.
A lot of the "posts" next to each other (ie, 55,56,57,58) are all very similar. So it want to jumble them up.

Chronicle · 30 Dec 2006 at 17:44

I don't want just a random one (or three).
I need to reset the ID's to something else, easily.

It is a complicated (ish) script, that is basically like a news script. It has multiple pages (as it splits pages up into groups of 10 posts).

Using that method won't work I dont think

Chronicle · 30 Dec 2006 at 20:25

Thanks. But nah, didn't really help. This isn't so much a PHP, more a mysql question. I just need to reorder the ID's in a table, randomly (or at least... so it is different to what it is now).

Chronicle · 30 Dec 2006 at 21:12

No. That is the whole point. I just need to set the IDs ONCE to something new (And random).