Doesn't Equal in SQL

Question

Hi Everyone:

I am wondering if there is some way to do a doesn't equal command in MYSQL. In other words, can you do a command like this: "SELECT * FROM someTitle WHERE someLabel != 'something'"? My code is returning an error when I attempt this.

Thanks for any help!

Answer 1

Use someLabel <> 'something' instead.

Answer 2

try this

SELECT * FROM someTitle WHERE someLabel <> 'something'

Answer 3

Try <> instead of !=

Answer 4

In SQL, like VB, <> is used instead of !=.

You can therefore write the following:

SELECT * FROM someTitle WHERE someLabel <> 'something'

I'm not sure how <> can mean inequality; can anyone explain?

Answer 5

Replace != with <>