BITMAP_REMOVE

bitmap_remove

description

Syntax

BITMAP BITMAP_REMOVE(BITMAP bitmap, BIGINT input)

从Bitmap列中删除指定的值。

example

mysql [(none)]>select bitmap_to_string(bitmap_remove(bitmap_from_string('1, 2, 3'), 3)) res; 
+------+
| res  |
+------+
| 1,2  |
+------+

mysql [(none)]>select bitmap_to_string(bitmap_remove(bitmap_from_string('1, 2, 3'), null)) res;
+------+
| res  |
+------+
| NULL |
+------+

keywords

BITMAP_REMOVE,BITMAP