SQL Operators for MariaDB Community Server 10.5
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Community Server 10.5
Topics on this page:
Overview
Structured Query Language (SQL) operators are keywords and symbols used to perform common arithmetic, logical, and matching operations on columns and column data.
Operator | Description |
---|---|
See NOT | |
Not equal to | |
Modulo | |
Bitwise AND | |
See AND | |
Multiply | |
Add | |
Subtract | |
Divide | |
Assign value | |
Less than | |
Bitwise left shift | |
Less than or equal to | |
Equal to without special treatment for NULL | |
See "!=" | |
Equal to (if either value is NULL it returns NULL instead of 1 or 0) | |
Greater than | |
Greater than or equal to | |
Bitwise right shift | |
Bitwise exclusive OR | |
Bitwise OR | |
See OR | |
Bitwise not | |
Presence in all returned rows | |
Logical And. Evaluates to 1 if both operands are non-zero, 0 if one or both operands are 0, NULL if either is NULL. | |
Presence in any returned rows | |
Compares the return value of an expression to minimum and maximum arguments. Returns 1 if expression is greater than or equal to the minimum and less than or equal to the maximum, otherwise returns 0. | |
Casts strings to binary values | |
Performs integer division | |
Presence of returned rows | |
Presence of value in a list | |
Boolean comparison | |
Boolean comparison, negative | |
Performs pattern matching | |
Modulo | |
Logical not | |
Not present within a range | |
Not present in a list | |
Performs pattern matching, negative | |
Non-match to a Regular Expression | |
See NOT REGEXP | |
Logical Or | |
Performs Regular Expression matching | |
See REGEXP | |
See ANY | |
Performs Soundex matching | |
Logical Exclusive Or operator. Evaluates to 1 if an one operands is non-zero, zero if both are non-zero, NULL if either is NULL. |