What does the <>
sign mean in MySQL? I saw it in a query, and could not understand what it is.
MySQLi For Beginners The symbol <> in MySQL is same as not equal to operator (!=). Both gives the result in boolean or tinyint(1). If the condition becomes true, then the result will be 1 otherwise 0.
Here is the answer – Technically there is no difference between != and <>. Both of them work the same way and there is absolutely no difference in terms of performance or result.
It means not equal, so these two are equivalent
a != b
a <> b
Use != operator instead. <> is some oldy goldy way of operating NOT EQUAL TO.
It means 'Not Equal' just as !=
means 'Not Equal'.
Literally the symbols mean less than and greater than. Since those two operators are mutually exclusive, putting them together is an impossibility and therefore, NOT EQUAL.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With