sql operator equivalent to !=

Question

I want to select all the fields where a certain column is not a value I specify.

I tried this but it didn't work.

SELECT * 
FROM table 
WHERE columnname != value

My mistake.

It was another error so I thought it was wrong with != operator cause it was the first time I use it. Sorry guys!

Answer 1

WHERE NOT columnname = value

Answer 2

SELECT * 
FROM table 
WHERE columnname <> value

Answer 3

In SQL, I believe inequality is

<>

though many implementations also allow

!=

Answer 4

Either <> or !=

From: MySQL Manual (version 5.0)

<>, !=

Not equal:

mysql> SELECT '.01' <> '0.01'; -> 1 mysql> SELECT .01 <> '0.01'; -> 0 mysql> SELECT 'zapp' <> 'zappp'; -> 1

Answer 5

For MySQL: != or <> are correct.

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html

You should consider NULL columns also. You can do WHERE columnname IS NOT NULL also.

Answer 6

NOT IN is one flavor and here's a tsql negate example

Answer 7

You need to post the query you are using, because != works fine for me in MySQL 4.1

As others mentioned, <> is equivalent. The != is ANSI standard (99 I believe).