SQL comparison operators

-----------------: | :------------------------------------------------------- | :------------------------- | | = | Equal to | 123 = 123 | | <> | Not equal to | 123 <> 456 | | != | Not equal to | 123 != 456 | | > | Greater than | 3 > 2 | | >= | Greater than or equal to | 3 >= 2 | | < | Less than | 1 < 2 | | <= | Less than or equal to | 1 <= 2 | | IS DISTINCT FROM | Is distinct from | 0 IS DISTINCT FROM 1 | | IS NOT DISTINCT FROM | Is not distinct from | 0 IS NOT DISTINCT FROM 1 | | ~ | Matches a regular expression | 'abc' ~ 'a.*' | | ~* | Matches a regular expression (case-insensitive) | 'Abc' ~* 'A.*' | | !~ | Does not match a regular expression | 'abc' !~ 'd.*' | | !~* | Does not match a regular expression (case-insensitive) | 'Abc' !~* 'a.*' |

source: /shared/sql-reference/operators/comparison.md

<!-- The content of this page is at /content/shared/sql-reference/operators/comparison.md -->