What does <> mean on SQL

Question

I was looking for what the <> mean on sql syntax but it was hard to google for it since google removes my special characters.

Specifically I was trying to figure out what the following means:

... AND (s1.skips > 0 OR s1.fails <> 1 OR s2.skips > 0);

Is there any clear documentation talking about the <> clause?

`<>` means not equal. See also [this SO question](http://stackoverflow.com/questions/723195/should-i-use-or-for-not-equal-in-tsql). — Ben Whaley, Apr 22 '14 at 18:45

score 6 · Answer 1 · answered Apr 22 '14 at 18:45

6

Please have a look at the documentation.

answered Apr 22 '14 at 18:45

Zwirbelbart

score 4 · Answer 2 · answered Apr 22 '14 at 18:46

4

Of course, it's the "not equal"-operator, same as !=, see manual

answered Apr 22 '14 at 18:46

VMai

score 2 · Accepted Answer · answered Apr 22 '14 at 18:45

<> is the equivalent of != in many other programming languages.

Specifically, your MySQL query makes the following restrictions if any of these are true:

3 Answers3