• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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
0
Neil_Bradley
Asked:
Neil_Bradley
1 Solution
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now