Comcast,
Simply order by the random function, RAND(). For example:
SELECT aff.*
FROM financial_affiliates AS aff
WHERE aff.state = 'wa'
AND aff.category = '3'
ORDER BY RAND();
Regards,
Adam
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
Sent: Wednesday, Septemb
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug, et al --
...and then David T-G said...
%
% ...and then Comcast said...
% %
% % I would like to ORDER BY RANDOM - is there an easy way to do that.
%
...
% I don't know if you can select random() like you can select count() but
% perhaps you d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug --
...and then Comcast said...
%
% I am querying a table and using the following statement:
%
% SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY
name
%
% I would like to ORDER BY RANDOM - is there an easy way
