clickhouseSelect rows with any of specified values in array column
SELECT * FROM tbl3 WHERE hasAny(list, ['a', 'd'])ctrl + ctbl3table with array column in it | hasAnywill return |
listname of the array column | ['a', 'd']values to search in array column |
Usage example
SELECT * FROM tbl3 WHERE hasAny(list, ['a', 'd'])output
┌──────────────────ts─┬─list──────────┐
│ 2022-01-14 17:41:32 │ ['a','b','c'] │
│ 2022-01-14 17:41:38 │ ['b','c','d'] │
└─────────────────────┴───────────────┘Related
More of Clickhouse
- Convert array to rows
- Get total database size
- How to execute SQL query from a file
- How to restart Clickhouse server
- List all tables from all database
- Using variables in queries
- Select where date column is between dates
- Select countIf usage example
- Select sumIf query example
- Get table size
See more codes...