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 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]
