toolsko

Choose your language

ToolsKo is written in English. Prefer another language? Open a translated version of this public page.

Browser language suggestion: English. You can choose any language below.

Translation opens in a new tab using Google Translate. It receives this public page URL. Automatic translations may contain mistakes; use the original English page for tool inputs, downloads, and generated documents.

Your choice is remembered on this browser when storage is available. Use Language in the header to change it.

SQL IN Clause Generator (List to IN (…))

Turn a pasted list (from Excel, emails, IDs) into a SQL IN (…) clause with quotes, escaping and duplicates removed.

Tool inputs stay in your browser · optional AI search sends your query

Good to know: Paste one value per line (like a column from Excel). Text is wrapped in single quotes and apostrophes are escaped, so O’Brien does not break the query.

How to use it (step by step)

  1. 1Type or paste your text into the “Values (one per line)” box. There is already an example in it so you can see how it works; press Clear to start with your own.
  2. 2Choose your settings: “Column name”, “Quotes”, “Remove duplicates”, “Split into groups (Oracle limit 1000)”.
  3. 3The answer appears right away in the “SQL” box. No button needed.
  4. 4Press Copy and paste the result wherever you need it.

Words to know

Escape / unescape
Adding a backslash or code before special characters (like quotes) so they do not break your code. Unescape turns them back.
SQL
The language used to ask a database for data, e.g. SELECT name FROM users.
Array / list
An ordered collection of items, like ["apple", "banana"]. Every programming language has one.

More in Developer

Git Commit Message Generator (Conventional Commits)Write clear commit messages like “feat(auth): add Google login” and get the git command, with checks for length and style.Semantic Version (SemVer) Calculator & Range CheckerCompare versions, see the next major/minor/patch, and check if a version matches npm ranges like ^1.2.0 or ~2.1.List to Array Converter (JSON, JS, Python, PHP…)Turn a pasted list into an array for JSON, JavaScript, Python, PHP, Java, C#, Go or a comma-separated line.cURL to Code Converter (fetch, Axios, Python, PHP)Paste a curl command (from API docs or Chrome “Copy as cURL”) and get JavaScript fetch, Axios, Python requests or PHP code.Markdown Table of Contents GeneratorPaste a Markdown document and get a clickable table of contents with GitHub-style links.Common Regex Patterns (Email, URL, PH Mobile…)Ready-made regular expressions for email, URL, Philippine mobile numbers, IP, dates, passwords and more — explained and testable.