SQL WHERE Builder
Visual condition builder — pick column, operator, and value; mix AND / OR with auto-grouping.
Conditions
WHERE
Generated SQL
SELECT id, email, status, created_at FROM users WHERE (status = 'active' AND created_at > '2024-01-01');
Operators
Comparison (=, <>, <, <=, >, >=), range (BETWEEN), set (IN), pattern (LIKE), and null check (IS NULL / IS NOT NULL).
Combining
Conditions are joined with AND by default. Toggle to OR per row. Parentheses are added automatically when you mix operators.
You might also like
- JSONPath TesterQuery JSON with JSONPath expressions and see the results live.
- SQL DiffCompare two SQL queries or schemas after canonical formatting — ignore whitespace and casing noise.
- SQL Query HighlighterColor-coded SQL with a clause-by-clause breakdown — SELECT, FROM, JOIN, WHERE, GROUP BY explained.
- Cron Expression Builder & ExplainerRead any cron expression in plain English and preview the next few run times.