Skip to content

This page is available in Markdown format. Markdown is recommended for AI consumption. See https://clickhouse.com/docs/reference/functions/regular-functions/in-functions/index.md for this page, orhttps://clickhouse.com/llms.txt for the full documentation index.

ClickHouse Docs

ClickHouse Cloud

ClickHouse Cloud

ClickHouse Managed Postgres

Open source

Agentic Data Stack

Kubernetes Operator

Language clients

Development & contributing

49.6k Sign in Get Started

/

Home
SQL Reference
- Syntax
- Loading…
- Overview
  EXISTS
  Distributed DDL
Data Types
Engines
- Overview
- Overview
  Loading…
  Overview
  Log table engine
  StripeLog table engine
  TinyLog table engine
  Loading…
  Loading…
- Loading…
Functions
- Functions Overview
- Overview
  AI
  Arithmetic
  Arrays
  arrayJoin
  Bit
  Bitmap
  Comparison
  Conditional
  Dates and time
  Distance
  Embedded dictionary
  Encoding
  Encryption
  Dictionaries
  Files
  Financial
  Nullable
  Loading…
  Hash
  IN Operator
  Introspection
  IP Addresses
  JSON
  Logical
  Machine Learning
  Mathematical
  NLP
  NumericIndexedVector
  Other
  Random number
  Rounding
  String splitting
  String
  String replacement
  String search
  TimeSeries
  Time window
  Tuples
  Maps
  Type conversion
  ULIDs
  uniqTheta
  URLs
  UUIDs
- Overview
  Combinators
  GROUPING
  Parametric
  Loading…
- Loading…
- Loading…
- UDF
  WebAssembly UDFs
Formats
Interfaces
- Native Protocol
- Native Format
Settings
- Overview
- Loading…
- Session Settings
  Loading…
- MergeTree tables settings
  Loading…
- Format Settings
  Loading…
- Beta and experimental features
System Tables
Data Lakes
- Overview

English

Regular functions

Functions for Implementing the IN Operator

|View as Markdown|Edit this page|Report an issue|

Set up docs MCP

Choose your path

in, notIn, globalIn, globalNotIn

See the section IN operators.

PreviousHash NextIntrospection

On this page

in, notIn, globalIn, globalNotIn

Navigation