From: Peter Brawley
Date: March 22 2007 4:32pm
Subject: Re: Finding a record in a result set
List-Archive: http://lists.mysql.com/mysql/205739
Message-Id: <4602AFA9.2090107@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >I want to do a query of all employees from Maine, ordered by hiring date,
 >and figure out where Joe falls in that list. (i.e. which record number 
is he?)

If 'Joe' is a unique name LOL...

SELECT 1 + COUNT(*)
FROM employees
WHERE name <> 'Joe' AND state = 'MA' AND hiredate < <datevalue>;

PB

James Tu wrote:
> Is there some quick way to do the following in MySQL?  (I know I can 
> use PHP to search through the result set, but I wanted to see if 
> there's a quick way using some sort of query)
>
> Let's say I know that Joe is from Maine.
> I want to do a query of all employees from Maine, ordered by hiring 
> date, and figure out where Joe falls in that list. (i.e. which record 
> number is he?)
>
> -James
>
>
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=peter.brawley@stripped
>
>
>
> --No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 
> 3/22/2007 7:44 AM
>
>