Paste or type values below. Tokens separated by newlines, spaces, tabs, commas, or semicolons are validated and built into a SQL WHERE … IN (…) clause in the layout you choose.
Delimiters: newlines, spaces, tabs, comma, semicolon — commas inside values are not supported.
Lines: 0
Columns: 0
Selection: 0 chars
Value type
IN list layout
Lines: 0
Columns: 0
Selection: 0 chars
Features
- Multiple delimiters: splits on newlines, spaces, tabs, commas, and semicolons.
- String mode: wraps in single quotes; escapes internal quotes per SQL rules.
- Number mode: validates each token as a number (int, decimal, scientific).
- Column name: default col1; allows identifier chains like schema.table.col.
- IN list layout: vertical (one per line), horizontal (single line), or wrap after N values per line.
Usage
- Paste or type your list in the input area.
- Set column name and value type (string or number).
- Click Build IN clause to validate and fill the SQL output.
- Pick how values are formatted inside IN: vertical, horizontal, or N values per line.
- Copy or download from the output editor.
Notes
- Commas and line breaks inside a value act as delimiters; multi-token strings with embedded commas are not supported.
- Review the final SQL for your engine (quoted identifiers, case sensitivity, etc.).
