> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators.md).

# Comparison Operators

Learn about comparison operators in MariaDB Server SQL. This section details operators like =, >, <, and LIKE used to compare values in conditions, essential for filtering and joining data.

* [BETWEEN AND](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/between-and.md)
* [COALESCE](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/coalesce.md)
* [=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/equal.md)
* [>=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/greater-than-or-equal.md)
* [>](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/greater-than.md)
* [GREATEST](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/greatest.md)
* [IN](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/in.md)
* [INTERVAL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/interval.md)
* [IS JSON](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-json.md)
* [IS NOT NULL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-not-null.md)
* [IS NOT](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-not.md)
* [IS NULL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-null.md)
* [IS](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is.md)
* [ISNULL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/isnull.md)
* [LEAST](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/least.md)
* [<=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/less-than-or-equal.md)
* [<](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/less-than.md)
* [NOT BETWEEN](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/not-between.md)
* [!=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/not-equal.md)
* [NOT IN](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/not-in.md)
* [<=>](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/null-safe-equal.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}
