SQL WHERE Clause Builder
Construct precise conditional filter statements using logical operators (AND/OR) and relational conditions.
1 condition
| Connector | Column Name | Operator | Value | Remove |
|---|---|---|---|---|
Valid Query
SQL WHERE Operators Reference
| Operator | Description | Example |
|---|---|---|
| = | Equal | status = 'active' |
| LIKE | Search for a specified pattern | email LIKE '%@gmail.com' |
| IN | Check if value matches any value in a list | role IN ('admin', 'editor') |
| IS NULL | Check for missing/null values | deleted_at IS NULL |
Frequently Asked Questions
Text and date values should be enclosed in single quotes (e.g.,
'active' or '2026-01-01'), while numeric values can be entered directly without quotes (e.g., 100). For lists used with IN, separate items with commas inside quotes or brackets depending on your SQL engine.