SQL Operators for MariaDB Community Server 10.6
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Reference for MariaDB Community Server 10.6
Topics on this page:
Structured Query Language (SQL) operators are keywords and symbols used to perform common arithmetic, logical, and matching operations on columns and column data.
Not equal to
Bitwise left shift
Less than or equal to
Equal to without special treatment for NULL
Equal to (if either value is NULL it returns NULL instead of 1 or 0)
Greater than or equal to
Bitwise right shift
Bitwise exclusive OR
Presence in all returned rows
Logical And. Evaluates to 1 if both operators are non-zero, 0 if one or both operators 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, negative
Performs pattern matching
Not present within a range
Not present in a list
Performs pattern matching, negative
Non-match to a Regular Expression
See NOT REGEXP
Performs Regular Expression matching
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.