Randomised rows & specific row

Question

I am wondering if it is possible to get a random array of ID's from a table but include one in particular?

So say I have 200 rows, I might limit my script to output 20 but one of the rows must include id 2 (for example).

Not sure if this is possible, would appreciate any help received.

Yes, the specific id will change each time - but I can work out which id that is. However it's including this id with a bunch of random rows — Andrew, Sep 08 '13 at 03:32

score 1 · Accepted Answer · answered Sep 08 '13 at 03:39

1

select id, if(id = 2, -1, rand()) as sort from my_table order by sort limit 20

answered Sep 08 '13 at 03:39

Lee

Thank you this worked perfectly, I created an array with the results, shuffled the array and then used this in a seperate query to give me the results I needed :D – Andrew Sep 08 '13 at 12:00

score 0 · Answer 2 · edited May 23 '17 at 12:14

0

Not the final solution, but maybe this thread helps you:

By the way: I'd handle the randomstuff within the script (e.g. PHP) with cached (e.g. Memcached) datasets. But that depends on your goal.

edited May 23 '17 at 12:14

Community

answered Sep 08 '13 at 03:44

Mr. B.

2 Answers2