SQL Operators for MariaDB Xpand 6.0
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Reference for MariaDB Xpand 6.0
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.
Negated equality with special treatment for NULL
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.
Bitwise left shift
Less than or equal to
Equality without special treatment for NULL
Equality with special treatment of NULL
Greater than or equal to
Bitwise right shift
Bitwise exclusive "or"
Presence in any returned rows
Inclusion in a range
Casts strings to binary values
Presence of returned rows
Presence of value in a list
Negated boolean comparison
Negated inclusion in a range
Not present in a list
Negated pattern matching
Negated Regular Expression matching
See NOT REGEXP
Regular Expression matching
Logical Exclusive "or" operator