Operators for MariaDB Xpand

Overview

This page describes Xpand's support for SQL operators.

Supported Operators

Xpand supports the following operators:

  • :=

  • !

  • !=

  • *

  • /

  • &

  • &&

  • %

  • ^

  • +

  • <

  • <<

  • <=

  • <=>

  • =

  • =

  • >

  • >=

  • >>

  • |

  • ||

  • ~

  • BETWEEN AND

    • If one of the values being compared for BETWEEN is NULL, Xpand will return NULL

  • BINARY OPERATOR

  • IS

  • IS NOT

  • IS NOT NULL

  • IS NULL

  • LIKE

  • MOD

  • NOT BETWEEN

  • NOT IN

  • NOT LIKE

  • NOT REGEXP

  • REGEXP

  • RLIKE

  • XOR

A list of supported SQL operators is available: