adding...
SELECT rand() AS RandomColumn, OtherQueryFields, .......
FROM .......
WHERE .......
ORDER BY RandomColumn
to the query but am not sure if this will produce a good randomisation, it
doesn't need to be perfect, just good.
I am selecting about 800-900 records of which 400-800 will be used (don't
ask!) and I need to make sure that (on average) they are all used.
--
James Smith
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
