# Where clauses

A `WHERE` clause allows you to add conditionals into your SQL statement that fetch data only if certain criteria is met.

## Basic WHERE clause

When defining a where condition in a SQL statement it typically reads like:

```sql
SELECT * FROM table_name WHERE id = 100
```

Each condition typically follows the format of: `column` `operator` `value`. We offer a number of [Operators](https://outerbase.gitbook.io/untitled/query-builder/operators) that help pre-compose the proper order and formatting to make it easier.

```typescript
const { data, error } = db
    .selectFrom([
        { 
            table: 'users', 
            columns: [
                'id', 
                'created_at', 
                'deleted_at'
            ]
        }
    ])
    .where(isNotNull('deleted_at'))
    .query()
```

## Multiple WHERE clauses

You can chain together multiple WHERE clauses to narrow down the rows that are returned.

```typescript
const { data, error } = db
    .selectFrom([
        { 
            table: 'users', 
            columns: [
                'id', 
                'created_at', 
                'deleted_at'
            ]
        }
    ])
    .where(isNotNull('deleted_at')) // User is not deleted
    .where(equalsNumber('id', 100)) // User ID is 100
    .query()
```