Comments on: Syntax of the day: IS TRUE and IS FALSE https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false Blog by Shlomi Noach Fri, 27 Jan 2012 06:01:53 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Log Buffer #256, A Carnival of the Vanities for DBAs | The Pythian Blog https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false/comment-page-1#comment-67390 Fri, 27 Jan 2012 06:01:53 +0000 https://shlomi-noach.github.io/blog/?p=4198#comment-67390 […] makes for a true statement? Shlomi Noach […]

]]> By: To NULL or NOT to NULL that is the question. | MySQL Fanboy https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false/comment-page-1#comment-67339 Thu, 26 Jan 2012 17:18:57 +0000 https://shlomi-noach.github.io/blog/?p=4198#comment-67339 […] liked Shlomi Noach post on “IS TRUE and IS FALSE“.  This kind of logic create […]

]]> By: Daniël van Eeden https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false/comment-page-1#comment-67338 Thu, 26 Jan 2012 17:16:36 +0000 https://shlomi-noach.github.io/blog/?p=4198#comment-67338 And there also is the <=> operator.

]]> By: Mark Grennan https://shlomi-noach.github.io/blog/mysql/syntax-of-the-day-is-true-and-is-false/comment-page-1#comment-67330 Thu, 26 Jan 2012 16:19:26 +0000 https://shlomi-noach.github.io/blog/?p=4198#comment-67330 if (1 = true) and ( 1 is TRUE) and (NULL is not TRUE), TRUE, FALSE);

Or,

NULL is never TRUE or FALSE but
NULL is always NOT TRUE or NOT FALSE;

mysql> select NULL is not FALSE;
+——————-+
| NULL is not FALSE |
+——————-+
| 1 |
+——————-+

]]>