Is there a way to use Order by RAND() for a query so that it returns a list of results and guarantees that adjacent values will be at least 'x' from each other, on either side? The results are all numbers, no strings.
So if it returns 5 results r1 thru r5
abs(r2 - r1) is > 15
abs(r3- r2) is > 15
abs(r4 - r3) is > 15
abs(r5 - r4) is > 15
Eventually I want to get to the point where I can guarantee that no sooner than r6 will a value be < 15 from r1 (remembering that the results are deliberately not sorted iin order, but rather, are random - except for that spacing minimum of 15). Then r7 would be the soonest that a value would be < 15 from r2, etc.