bitmap_from_string

description

Syntax

BITMAP BITMAP_FROM_STRING(VARCHAR input)

Convert a string into a bitmap. The input string should be a comma separated UNIT32. For example: input string “0, 1, 2” will be converted to a Bitmap with bit 0, 1, 2 set. If input string is invalid, return NULL.

example

  1. mysql> select bitmap_to_string(bitmap_empty());
  2. +----------------------------------+
  3. | bitmap_to_string(bitmap_empty()) |
  4. +----------------------------------+
  5. |                                  |
  6. +----------------------------------+
  8. mysql> select bitmap_to_string(bitmap_from_string("0, 1, 2"));
  9. +-------------------------------------------------+
  10. | bitmap_to_string(bitmap_from_string('0, 1, 2')) |
  11. +-------------------------------------------------+
  12. | 0,1,2                                           |
  13. +-------------------------------------------------+
  15. mysql> select bitmap_from_string("-1, 0, 1, 2");
  16. +-----------------------------------+
  17. | bitmap_from_string('-1, 0, 1, 2') |
  18. +-----------------------------------+
  19. | NULL                              |
  20. +-----------------------------------+

keyword

  1. BITMAP_FROM_STRING,BITMAP