SQL Operators for MariaDB Xpand

The parent of this page is: Reference for MariaDB Xpand

Topics on this page:

Overview

A summary of SQL operators across MariaDB Xpand versions:

Operator	In 23.09?	In 6.1?	In 6.0?	In 5.3?
!	23.09	6.1	6.0	5.3
!=	23.09	6.1	6.0	5.3
%	23.09	6.1	6.0	5.3
&	23.09	6.1	6.0	5.3
&&	23.09	6.1	6.0	5.3
*	23.09	6.1	6.0	5.3
+	23.09	6.1	6.0	5.3
-	23.09	6.1	6.0	5.3
->	23.09	6.1	6.0	5.3
->>	23.09	6.1	6.0	5.3
/	23.09	6.1	6.0	5.3
::	23.09	6.1	6.0	5.3
:=	23.09	6.1	6.0	5.3
<	23.09	6.1	6.0	5.3
<<	23.09	6.1	6.0	5.3
<=	23.09	6.1	6.0	5.3
<=>	23.09	6.1	6.0	5.3
<>	23.09	6.1	6.0	5.3
=	23.09	6.1	6.0	5.3
>	23.09	6.1	6.0	5.3
>=	23.09	6.1	6.0	5.3
>>	23.09	6.1	6.0	5.3
AND	23.09	6.1	6.0	5.3
ANY	23.09	6.1	6.0	5.3
BETWEEN	23.09	6.1	6.0	5.3
BINARY	23.09	6.1	6.0	5.3
DIV	23.09	6.1	6.0	5.3
EXISTS	23.09	6.1	6.0	5.3
IN	23.09	6.1	6.0	5.3
IS	23.09	6.1	6.0	5.3
IS NOT	23.09	6.1	6.0	5.3
LIKE	23.09	6.1	6.0	5.3
MOD	23.09	6.1	6.0	5.3
NOT	23.09	6.1	6.0	5.3
NOT BETWEEN	23.09	6.1	6.0	5.3
NOT IN	23.09	6.1	6.0	5.3
NOT LIKE	23.09	6.1	6.0	5.3
NOT REGEXP	23.09	6.1	6.0	5.3
NOT RLIKE	23.09	6.1	6.0	5.3
OR	23.09	6.1	6.0	5.3
REGEXP	23.09	6.1	6.0	5.3
RLIKE	23.09	6.1	6.0	5.3
SOME	23.09	6.1	6.0	5.3
SOUNDS LIKE	23.09	6.1	6.0	5.3
XOR	23.09	6.1	6.0	5.3
^	23.09	6.1	6.0	5.3
\|	23.09	6.1	6.0	5.3
\|\|	23.09	6.1	6.0	5.3
~	23.09	6.1	6.0	5.3