How does auto-quoting decide what to quote?

In auto mode, a value that matches a clean number pattern (optional sign, digits, optional decimal) is left unquoted; everything else is wrapped in single quotes with any embedded single quotes doubled for SQL safety.

What separators can I paste?

Values can be separated by newlines, commas, semicolons, or tabs — or any mix of them. Each value is trimmed and empty entries are dropped, so messy pasted lists still work.

Can it build a NOT IN clause?

Yes. Tick the NOT IN box and the operator switches from IN to NOT IN while keeping the same value list and quoting.

Does it remove duplicate values?

Yes, when de-duplication is enabled it keeps only the first occurrence of each value, which shrinks the clause and avoids redundant comparisons.

Can I get one value per line for long lists?

Yes. The multiline option lays each value on its own indented line inside the parentheses, which is far easier to read and diff for large lists.

Is my data sent anywhere?

No. The clause is built entirely in your browser with JavaScript — no value ever leaves your device.

SQL IN Clause Builder

Have a column of IDs from a spreadsheet, log, or query result and need them inside a WHERE id IN (...)? Paste the list and this tool assembles a clean, correctly quoted SQL IN clause ready to drop into your query.

How it works

The builder runs a small pipeline:

Split the input on newlines, commas, semicolons, or tabs, trim each piece, and drop empties.
De-duplicate (optional) by keeping the first occurrence of each value.
Quote each value. In auto mode, anything matching a clean number pattern stays bare and everything else is wrapped in single quotes with ' escaped as ''. You can also force always-quote or never-quote.
Assemble column IN (...) — or NOT IN if toggled — joining values inline, or one per indented line in multiline mode.

Example

Pasting 1001, 1002, 1002, 1007 with column id, auto quoting, de-dupe on:

id IN (1001, 1002, 1007)

A list of strings like GB, US, FR becomes:

country IN ('GB', 'US', 'FR')

Option	Effect
Auto quoting	Numbers bare, strings single-quoted
De-duplicate	Removes repeated values
NOT IN	Swaps IN for NOT IN
Multiline	One value per indented line

Everything runs in your browser — nothing is uploaded.