SQL IN clause builder

Turn a list of values into a WHERE col IN (…) statement in your browser. Nothing is uploaded or executed.

Table Column

Text helper only. Nothing is executed against a database.

How to use the SQL IN clause builder

Set table and column names (letters, digits, underscore).
Paste one value per line. Tick unquoted numbers if the column is numeric.
Copy the SELECT. Cap is 500 values.

Why a helper

Hand-quoting hundreds of ids is how commas go missing. Empty lines are skipped. Empty as NULL is optional. Dedupe the list on the line deduper first if you need unique ids.

Nothing is uploaded

Text only. The statement is not executed.

SQL IN clause builder FAQ

Identifiers?

schema.table is allowed. Odd names are rejected so the output cannot inject quotes.

CSV columns?

Use INSERT from CSV when you have several columns.