SQL IN Clause Generator

Paste values below to generate a SQL IN list or a WHERE clause with multiple conditions joined by AND or OR.

Input values (one per line):

Field / column name:

Output format:

Wrap values in single quotes
Trim whitespace
Remove blank lines
For LIKE formats, wrap values as %value%

SQL output:

Example

apple
banana
cherry

Example output:

WHERE fruit = 'apple'
OR fruit = 'banana'
OR fruit = 'cherry'