12
Still doing a series of tests in Mysql I noticed that the operator <=>
worked equivalent to =
for the case tested, the following:
SELECT * FROM `client` WHERE avatar <=> NULL
This returned the only two items it has in the base, both for <=>
how much to =
. Another test I did was with the <>
, in which returns all the items that the column avatar
is different NULL
, for this select
up.
What purpose of the operator <=>
in Mysql? In fact there is equivalence with the equal operator? When should it be used?