In

in compares values and returns true if value1 equals value2 (OR value3, etc., if specified).

Syntax

in(value1, value2, ...)

value1 is the column or value to check.

value2, ... is the list of columns or values to check.

Metabase will return rows where the value1 equals value2 OR value3, etc. Matches must be exact (e.g., strings are case sensitive).

You can choose multiple columns. For example, let’s say you wanted to look for the string Gadget in both the [Title] and [Category] columns. You could write:

in("Gadget", [Title], [Category])

which would return rows where either the title or the category columns were equal to “Gadget”.

Related functions

SQL

in works like SQL’s in function.

So if you have the expression: in[title], "Lightweight Wool Computer", "Aerodynamic Cotton Lamp"), in SQL, it would be:

title IN ('Lightweight Wool Computer', 'Aerodynamic Cotton Lamp')

But under the hood, Metabase translates this IN expression to a WHERE clause that uses the OR operator:

WHERE
  title = 'Lightweight Wool Computer'
  OR title = 'Aerodynamic Cotton Lamp'

Accepted data types