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'
Some other thing: Instead of saying "where x!=a and x!=b" you could also say "where !(x==a or x==b)". That's known as de Morgan's law. (sometimes the math course at university pays off, surprise!) 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]
