Hi everybody,
I know this is not exactly what SQL was meant to do but is there a way to retrieve a result in a random order?
The statement would be like this:
SELECT id, shopid, [...] FROM products WHERE special_offer='Y' ORDER BY [random].
The ids are jagged so selecting an id at random and checking
a) whether such a product exists and
b) whether it is a special offer
would take too long.
Any ideas?
As always thanks in advance,
Dominique
I know this is not exactly what SQL was meant to do but is there a way to retrieve a result in a random order?
The statement would be like this:
SELECT id, shopid, [...] FROM products WHERE special_offer='Y' ORDER BY [random].
The ids are jagged so selecting an id at random and checking
a) whether such a product exists and
b) whether it is a special offer
would take too long.
Any ideas?
As always thanks in advance,
Dominique