Jess,

You should use an AND (&&) instead of the OR. You result is everything, correct? When the query is doing the machinename != 'FIND_ME', the record(s) with machinename = 'OPEN' are being returned. Likewise, when the machinename != 'OPEN' is being performed, the records(s) with machinename = 'FIND_ME' will be returned. Thus, every record is being returned. If you use AND the query will return your intended result, all the records where machinename != 'FIND_ME' AND machinename != 'OPEN'.

HTH
Matt

At 10:22 AM 1/9/2004, you wrote:
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'

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


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



Reply via email to