Menu

MariaDB Operators

Browse MariaDB operators and predicates. Unlike functions, operators use operands rather than arguments in parentheses. This section includes the MariaDB 12.3 IS JSON predicate for validating JSON types and unique keys.

  1. BINARY

    In MariaDB, BINARY is a built-in operator that converts a given string to a binary string.

  2. CASE

    MariaDB CASE implements conditional logic in SQL expressions. Learn simple CASE, searched CASE WHEN, first-match behavior, ELSE NULL behavior, and CASE statement differences.

  3. DIV

    In MariaDB, DIV is a built-in operator that performs divisions and returns an integer result.

  4. EXCEPT

    In MariaDB, EXCEPT is a built-in set operator that returns the difference of two result sets.

  5. INTERSECT

    In MariaDB, INTERSECT is a built-in set operator that returns the intersection of two result sets, that is, those rows existing in both result sets.

  6. IS JSON

    Validate MariaDB JSON expressions with IS JSON. Check VALUE, ARRAY, OBJECT, SCALAR, and unique keys; added in MariaDB 12.3.

  7. LIKE

    In MariaDB, the LIKE operator matches a given string against a given pattern and returns the matching result.

  8. MINUS

    In MariaDB, MINUS is a built-in set operator that returns the difference of two result sets.

  9. MOD

    In MariaDB, MOD is a built-in operator that returns the remainder when one number is divided by another.

  10. NOT LIKE

    In MariaDB, the NOT LIKE operator is negation operation of the LIKE operator.

  11. REGEXP

    In MariaDB, the REGEXP operator checks whether a string matches a regular expression.

  12. RLIKE

    In MariaDB, the RLIKE operator checks whether a string matches a regular expression.

  13. UNION

    In MariaDB, UNION is a built-in set operator that returns the union of two result sets.