SQL IN Clause Generator

Paste values, one per line or comma-separated.

About this tool

Paste a list of values and get a SQL IN (...) clause ready to drop into a query. Input may be one value per line or comma-separated, and both styles can be mixed. Enable quoting for string values (each value single-quoted with embedded quotes escaped) or leave it off for numeric IDs.

Optionally remove duplicates and add a field prefix such as id to produce a full id IN (1, 2, 3). Blank values are dropped. All processing happens locally in your browser — nothing is sent anywhere.

Related tools

SQL FormatterJSON to MySQLDuplicate Line Remover