thaivh tools
All Tools

Text Joiner & SQL IN Clause Generator

Need to turn a list of IDs into a SQL WHERE IN() clause? Paste your values below — one per line — pick a preset or configure your own wrap and delimiter, and copy the result. Works for MySQL, PostgreSQL, CSV, and any custom format. No data leaves your browser.

Format: 'value', 'value'

Input: 0Output: 0

How to Use

Basic Usage

  1. Paste values one per line
  2. Choose a preset or configure options
  3. Copy the formatted output

SQL IN() Workflow

  1. Export IDs from a spreadsheet or query
  2. Paste into the input area
  3. Copy the quoted, comma-separated result
  4. Use in: WHERE id IN (…)

Presets

  • MySQL IN() — single-quoted, comma-sep
  • CSV — plain comma-separated
  • Quoted CSV — double-quoted CSV
  • Space Sep. — for CLI arguments

Common Use Cases

SQL WHERE IN()

Build IN clauses for MySQL, PostgreSQL, SQLite, or any SQL database from a column of IDs or values exported from a spreadsheet.

CSV Formatting

Convert a vertical list from a spreadsheet into a single CSV line for import, API payloads, or data pipeline inputs.

Config File Values

Format space-separated or pipe-delimited values for .env files, CI/CD environment variables, or shell scripts.

Data Cleanup

Remove duplicate entries and trim whitespace from messy lists before feeding them into a database, script, or API.

Frequently Asked Questions

How do I generate a SQL IN clause from a list?▾
Paste your values one per line into the input area. The default preset (MySQL IN) wraps each value in single quotes and joins them with commas: 'val1', 'val2', 'val3'. Copy the output and paste it into your SQL WHERE column IN (...) clause.
Does this tool work for PostgreSQL?▾
Yes. Click the PostgreSQL preset. It uses the same single-quote wrapping and comma-space delimiter. For PostgreSQL array literals, wrap the output in ARRAY[...] or '{...}' manually — the tool handles the value formatting.
Can I remove duplicate values from my list?▾
Check the 'Remove duplicates' checkbox. The tool performs case-sensitive deduplication, keeping the first occurrence of each value. The stats bar shows how many duplicates were removed.
How do I convert a list to CSV format?▾
Click the CSV preset to join values with commas and no wrapping. For values that contain commas, use the Quoted CSV preset which wraps each value in double quotes.
Is my data safe? Does anything get sent to a server?▾
All processing happens entirely in your browser using JavaScript. No data is transmitted to any server. You can verify this by disconnecting from the internet — the tool will continue to work.
Can I use a custom delimiter or wrap character?▾
Yes. Select 'Custom' from the wrap or delimiter dropdown and type any character(s) you want. Common custom delimiters include tab characters, semicolons, or multi-character strings like ' OR '.
What is the maximum number of lines this tool can handle?▾
The tool processes text client-side so it can handle thousands of lines without issues. For very large lists (100K+ lines), processing may take a moment but no data is sent to a server so there is no upload time.