not_null_or_empty

description

Syntax

BOOLEAN NOT_NULL_OR_EMPTY (VARCHAR str)

如果字符串为空字符串或者NULL，返回false。否则，返回true。

example

1. MySQL [(none)]> select not_null_or_empty(null);
2. +-------------------------+
3. | not_null_or_empty(NULL) |
4. +-------------------------+
5. |                       0 |
6. +-------------------------+

8. MySQL [(none)]> select not_null_or_empty("");
9. +-----------------------+
10. | not_null_or_empty('') |
11. +-----------------------+
12. |                     0 |
13. +-----------------------+

15. MySQL [(none)]> select not_null_or_empty("a");
16. +------------------------+
17. | not_null_or_empty('a') |
18. +------------------------+
19. |                      1 |
20. +------------------------+

keywords

1. NOT_NULL_OR_EMPTY