Re: Random SELECT on subset

2006-08-13 Thread Chris
Mark wrote: -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: maandag 14 augustus 2006 6:32 To: Mark Cc: mysql@lists.mysql.com Subject: Re: Random SELECT on subset Thanks to you, the query has been greatly simplified, but the result is still the same: every once in a

RE: Random SELECT on subset

2006-08-13 Thread Mark
> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: maandag 14 augustus 2006 6:32 > To: Mark > Cc: mysql@lists.mysql.com > Subject: Re: Random SELECT on subset > > > Thanks to you, the query has been greatly simplified, but > the result

Re: Random SELECT on subset

2006-08-13 Thread Chris
Mark wrote: -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: maandag 14 augustus 2006 4:54 To: Mark Cc: mysql@lists.mysql.com Subject: Re: Random SELECT on subset Hmm, this still does not do what I want: SELECT columnId FROM queue WHERE processed = '1' ORD

RE: Random SELECT on subset

2006-08-13 Thread Mark
> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: maandag 14 augustus 2006 4:54 > To: Mark > Cc: mysql@lists.mysql.com > Subject: Re: Random SELECT on subset Hmm, this still does not do what I want: SELECT columnId FROM queue WHERE processed =

Re: Random SELECT on subset

2006-08-13 Thread Chris
Mark wrote: -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: maandag 14 augustus 2006 4:18 To: Mark Cc: mysql@lists.mysql.com Subject: Re: Random SELECT on subset Then I want to select 4 random columnIDs, but only from the subset WHERE processed = '1' (so

RE: Random SELECT on subset

2006-08-13 Thread Mark
> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: maandag 14 augustus 2006 4:18 > To: Mark > Cc: mysql@lists.mysql.com > Subject: Re: Random SELECT on subset > > > Then I want to select 4 random columnIDs, but only from the > > subse

Re: Random SELECT on subset

2006-08-13 Thread Chris
Mark wrote: -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: maandag 14 augustus 2006 3:55 To: Mark Cc: mysql@lists.mysql.com Subject: Re: Random SELECT on subset In Perl, I'm trying to get 4 random entries from a subset "WHERE processed = '1'

RE: Random SELECT on subset

2006-08-13 Thread Mark
> -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: maandag 14 augustus 2006 3:55 > To: Mark > Cc: mysql@lists.mysql.com > Subject: Re: Random SELECT on subset > > > In Perl, I'm trying to get 4 random entries from a subset >

Re: Random SELECT on subset

2006-08-13 Thread Chris
Mark wrote: Dear MySQL-ers, Using MySQL 4.1.20, I'm trying to do a complex query on a subset; well, complex to me, that is. :) In Perl, I'm trying to get 4 random entries from a subset "WHERE processed = '1'" and "columnId" is unique. Like so: $sth = $dbh->prepare ("SELECT columnId FROM queue

Random SELECT on subset

2006-08-13 Thread Mark
Dear MySQL-ers, Using MySQL 4.1.20, I'm trying to do a complex query on a subset; well, complex to me, that is. :) In Perl, I'm trying to get 4 random entries from a subset "WHERE processed = '1'" and "columnId" is unique. Like so: $sth = $dbh->prepare ("SELECT columnId FROM queue WHERE columnI