SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:04 AM
| ||||
| ||||
 RE : SPAM ? Hi, > What's kind of the message you guys mentioned? Its always the same message from the same author with the same content, same date same hour, it’s the one below: > -----Message d'origine----- > De : Jerry Schwartz [mailto:jschwartz@the-infoshop.com] > Envoyé : jeudi 22 mars 2007 17:53 > À : peter.brawley@earthlink.net; '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  eter.brawley@earthlink.net]> > 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=p...@earthlink.net > > > > > > > > > > > > --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=j...e-infoshop.com > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=jacbrignon@online.fr      |
Linear Mode
