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