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:[EMAIL PROTECTED] > Envoyé : jeudi 22 mars 2007 17:53 > À : [EMAIL PROTECTED]; '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:[EMAIL PROTECTED] > > 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/[EMAIL PROTECTED] > > > > > > > > > > > > --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/[EMAIL PROTECTED] > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]