Re: How to find random records in a subset?

[Warren Young]

Brian Dunning wrote:

But I have to take it one more step: I want to first limit my found  set 
to those matching a different search criteria, and then find 50  of those.

SELECT id FROM bla WHERE whatever

That gets you a list of IDs that match the criteria.  Then select 50 
IDs, and issue the full-record SELECT for those 50.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]