null_or_empty
This function returns true when the string is empty or NULL. Otherwise, it returns false.
Syntaxβ
BOOLEAN NULL_OR_EMPTY (VARCHAR str)
BOOLEAN NULL_OR_EMPTY (any_array)
Examplesβ
MySQL > select null_or_empty(null);
+---------------------+
| null_or_empty(NULL) |
+---------------------+
| 1 |
+---------------------+
MySQL > select null_or_empty("");
+-------------------+
| null_or_empty('') |
+-------------------+
| 1 |
+-------------------+
MySQL > select null_or_empty("a");
+--------------------+
| null_or_empty('a') |
+--------------------+
| 0 |
+--------------------+
MySQL > select null_or_empty([]);
+-------------------+
| null_or_empty('') |
+-------------------+
| 1 |
+-------------------+
MySQL > select null_or_empty([1]);
+--------------------+
| null_or_empty('a') |
+--------------------+
| 0 |
+--------------------+
keywordβ
NULL_OR_EMPTY