# Where operators can be used

Comparison operators and functions can appear as conditions, such as part of the `WHERE` clause or join `ON` conditions. In addition, they can appear in the `SELECT` list or other locations where expressions can appear. In the latter case, they return 0 if false, 1 if true, and NULL if an input is NULL. For example:

```sql
SELECT t, t LIKE 'r%', t != 'red' FROM s WHERE t = 'red';

```

```output

+------+-------------+------------+
| t    | t LIKE 'r%' | t != 'red' |
+------+-------------+------------+
| red  |           1 |          0 |
+------+-------------+------------+

```

***

Modified at: April 24, 2021

Source: [/db/v9.1/reference/sql-reference/comparison-operators-and-functions/where-operators-can-be-used/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/comparison-operators-and-functions/where-operators-can-be-used/)

(An index of the documentation is available at /llms.txt)