9951 explained code solutions for 126 technologies


clickhouseHow to select based on Tuple element value


SELECT * FROM tbl4 WHERE person.name = 'Joe'ctrl + c
tbl4

name of the table with Tuple column

person

name of the created Tuple column

.name

name of the Tuple element

'Joe'

value to search for in person.name


Usage example

SELECT * FROM tbl4 WHERE person.name = 'Joe';
output
┌──────────────────ts─┬─person────┐
│ 2022-01-19 14:04:09 │ ('Joe',2) │
└─────────────────────┴───────────┘