Runs locally
SQL IN Clause
Quote lines as an SQL IN list.
Ctrl+Enter runs. Ctrl+Shift+Backspace clears.
Export and import are available after you sign in. Sign in
Quote lines as an SQL IN list. Runs in the browser. Nothing is uploaded.
About this tool
Copy a list of IDs or emails from a spreadsheet and get a ready IN list for your SQL query. Each line becomes a quoted value, and apostrophes are doubled.
How to use it
- 01
Paste the values, one per line.
- 02
Get the quoted IN list.
- 03
Paste it into WHERE column IN ….
FAQ
Frequently asked questions
How are apostrophes handled?
They are doubled, so O'Brien becomes 'O''Brien', which is valid SQL.
Are empty lines skipped?
Yes. Blank lines and surrounding spaces are removed.