Those Boring Tools
Developer ToolsPrivate by design

SQL IN Clause Generator

Paste a list of values (one per line or comma-separated) to generate a ready-to-paste SQL IN (...) clause.

How to use this tool

  1. 1Paste your values.
  2. 2Choose strings or numbers.
  3. 3Copy the generated IN clause.

Frequently asked questions

Does this escape special characters?+

Single quotes within string values are escaped by doubling them, the standard SQL escaping convention.

Related tools

Keep the boring tools boring.

If this saved you five minutes of nonsense, you can help keep the free tools running.

Buy the toolbox a coffee