Line tools
Line tools lets you trim, remove blanks and duplicates, sort, and number lines in your browser.
SQL IN clause generator
SQL IN clause generator lets you generate IN predicates with deduplication, NULL handling, and dialect quoting in your browser.
SQL IN clause generator
⌂ Inputs and results stay in this browser and are not automatically stored or sent.
Waiting for input
Input & settings
Values (one per line)TEXT · 0 B
Output
Waiting for input
Complete text result
How to use
Enter one value per line and set value type, column, dialect, duplicate handling, and NULL behavior.
Inspect quotes and leading zeros. NULL does not match like an ordinary IN value. Review the generated condition and consider parameterization in the executing application.
Examples
alpha
beta
O'ReillyPrinciples and limits
Each input is limited to 1,048,576 bytes, output to 33,554,432 bytes, and processing to 5,000 ms. Input is never silently truncated.
Guides
Related tools
SQL formatter
SQL formatter lets you format PostgreSQL, MySQL, or SQLite SQL without connecting to a database in your browser.