Name:
Anonymous
2007-04-11 10:03
ID:oipW5bkJ
One operator, <=>, everything over.
Name:
Anonymous
2007-04-11 12:25
ID:582OV1Dm
MySQL has a NULL-safe comparison operator <=> .
SELECT 1 = 1 yields 1
SELECT 1 = 0 yields 0
SELECT 1 = NULL yields NULL (stupid SQL)
SELECT 1 <=> NULL yields 0
SELECT NULL <=> NULL yields 1
SELECT 1 / 0 yields NULL (it should yield INFINITE)