SQL Operators for MariaDB Xpand 23.09
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 23.09
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 | |
Negated equality with special treatment for NULL | |
See MOD | |
Bitwise "and" | |
See AND | |
Multiplication | |
Addition | |
Subtraction | |
Extract a value from JSON data using a path expression. A string result is returned with its double quotes intact. | |
Extract a value from JSON data using a path expression. A string result is returned unquoted. | |
Floating point division | |
Extract a value from JSON data using an abbreviated path expression. A string result is returned unquoted. | |
Assign value | |
Less than | |
Bitwise left shift | |
Less than or equal to | |
Equality without special treatment for NULL | |
See "!=" | |
Equality with special treatment of NULL | |
Greater than | |
Greater than or equal to | |
Bitwise right shift | |
Bitwise exclusive "or" | |
Bitwise "or" | |
See OR | |
Bitwise negation | |
Logical "and" | |
Presence in any returned rows | |
Inclusion in a range | |
Casts strings to binary values | |
Integer division | |
Presence of returned rows | |
Presence of value in a list | |
Boolean comparison | |
Negated boolean comparison | |
Pattern matching | |
Modulo | |
Logical negation | |
Negated inclusion in a range | |
Not present in a list | |
Negated pattern matching | |
Negated Regular Expression matching | |
See NOT REGEXP | |
Logical "or" | |
Regular Expression matching | |
See REGEXP | |
See ANY | |
Soundex matching | |
Logical Exclusive "or" operator |