iframe-proxy | Sunbelt Computer Software

9 lines (7 loc) · 507 Bytes

select c.name from customer c where c.referee_id != 2 or c.referee_id is NULL;
/**MySQL uses three-valued logic -- TRUE, FALSE and UNKNOWN.
Anything compared to NULL evaluates to the third value: UNKNOWN.
That “anything” includes NULL itself!
That’s why MySQL provides the IS NULL and IS NOT NULL operators to specifically check for NULL.
Thus, one more condition 'referee_id IS NULL' should be added to the WHERE clause as below.*/
/**Cool! I'm glad that I figured this one out all by myself! ^ ^*/

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

_584.sql

Latest commit

History

_584.sql

File metadata and controls