NOT operator problem in MySQL

Question

I want to create an SQL command in a MySQL/PHP environment where the NOT operator is used. I have created the following piece of code:

"SELECT software.*, FROM software,softwarever WHERE  
software.ID = softwarever.ID AND (software.ID='$_GET[text]' OR
software.Name='$_GET[text]') 
NOT(software.ID='$_GET[extra_text]' OR software.Name='$_GET[extra_text]')";

When I go and execute it however it gives me error due to the NOT operator. Does anyone knows if there is a solution to this? Thanks in advance!

P.S. I don't want the NOT IN operator

Tony Lukasavage · Accepted Answer · 2011-05-05 19:06:06Z

4

You need to put and AND or OR before your NOT, depending on your logic. And lose the comma after your SELECT. For exmaple:

"
SELECT software.*
FROM   software,softwarever 
WHERE  software.ID = softwarever.ID 
AND    (software.ID='$_GET[text]' OR software.Name='$_GET[text]') 
OR NOT (software.ID='$_GET[extra_text]' OR software.Name='$_GET[extra_text]')
";

answered May 5, 2011 at 19:06

Tony Lukasavage

1,9351 gold badge14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

evan · Accepted Answer · 2011-05-05 19:06:12Z

3

You're missing AND/OR before the NOT.

The query doesn't know if you want X AND NOT Y or X OR NOT Y

answered May 5, 2011 at 19:06

evan

12.6k7 gold badges41 silver badges52 bronze badges

Collectives™ on Stack Overflow

NOT operator problem in MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related