SQL IN Clause Builder

Turn a list of values (one per line) into a quoted SQL IN (...) list.

About this tool

Duplicates are removed and single quotes are escaped. Many databases limit IN lists to a few thousand items; use a temporary table for larger sets.

Related: JSON Formatter & Validator · Base64 Encode & Decode · URL Encoder & Decoder · SHA-256 / SHA-1 Hash Generator · Unix Timestamp Converter