MySQL query

Is is possible to write a query to give me everything in a colum excelt a given value?
IE
SELECT trading
FROM operators
WHERE trading = 'everying except myValue
Thanks
LVL 5
Neil_BradleyWeb UX/UI DeveloperAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT trading
FROM operators
WHERE trading <> 'myValue
0
 
Cornelia YoderArtistCommented:
SELECT trading
FROM operators
WHERE trading != 'myValue'
0
 
Neil_BradleyWeb UX/UI DeveloperAuthor Commented:
Perfect. In playing with the problem I also discovered that this works too
SELECT trading
FROM operators
WHERE trading NOT  LIKE 'myValue%'
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Stoical85Commented:
you can just put NOT in front of your value
0
 
Cornelia YoderArtistCommented:
There are several good ways to do this, you were a little quick to hand all the points to the first person who jumped in.
0
 
Neil_BradleyWeb UX/UI DeveloperAuthor Commented:
Yes, I see now that there are multiple solutions to the question however as I was completely satisfied with the first correct answer and the speed of their response I awarded the points then and their and closed the question.

Since then more solutions have come to light each that work perfectly. These subsequent posts are much appreciated however I cannot now re open the question and re distribute the points.

Thanks to all who contributed.

Neil
0
 
Cornelia YoderArtistCommented:
Actually, you CAN reopen the question and assign points differently.  Just click on the Request Attention link in the question box at the top, and ask the moderator to reopen it.   However in this case, don't worry about it, as all the answers were just syntax differences.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.