http://lists.mysql.com/mysql?unsub=1
that link ought to help you.
Jacques Brignon wrote:
> Hi,
>
> I keep receiving this message by several dozens each day, how can this
> be stopped?
>
> Regards
>
> Jacques
>
>> -----Message d'origine-----
>> De : Jerry Schwartz [mailto:jschwartz@stripped]
>> Envoyé : jeudi 22 mars 2007 17:53
>> À : peter.brawley@stripped; 'James Tu'
>> Cc : 'MySQL List'
>> Objet : RE: Finding a record in a result set
>>
>> I don't think that will work. If there are 1,000 records that qualify
> but
>> none for Joe, then it will return 1,001. If Joe is in record 1 of the
>> retrieved record set, and there are 999 other people who match the
> WHERE
>> clause, then it will retrieve 1,000.
>>
>> Am I missing something?
>>
>> Regards,
>>
>> Jerry Schwartz
>> Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>>
>>
>>> -----Original Message-----
>>> From: Peter Brawley [mailto:peter.brawley@stripped]
>>> Sent: Thursday, March 22, 2007 12:33 PM
>>> To: James Tu
>>> Cc: MySQL List
>>> Subject: Re: Finding a record in a result set
>>>
>>> >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=1
>>>>
>>>>
>>>>
>>>> --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
>>>>
>>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:
>>> http://lists.mysql.com/mysql?unsub=1
>>>
>>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>
>
