Am Friday 09 January 2004 17:57 schrieb Stefan Kuhn: > Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: > > Could someone have a look at this syntax and give me some guidance what I > > may be overlooking? > > > > SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != > > 'OPEN' > > A query like "where x=a or s=b" will always return all values. Why? Because
Sorry, should read "where x!=a or s!=b" as in your mail. Stefan > the value is always differen from at least a or b. So such a query is > nonsense. > You want all records unequal to a and b, i. e. everything except a and b? > Use and. > Stefan > > > I can make the statement work individually, but when I try to add the > > 'OR' statement it fails to 'remove' the designated records from the > > display page. I have tried moving the 'FIND_ME' and 'OPEN' around and > > still get the same results. > > > > Any help would be appreciated > > > > Jess > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.558 / Virus Database: 350 - Release Date: 1/2/04 -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) ZÃlpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
