# Functions & Operators | Name | Description | Added | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [+](https://mariadb.com/docs/server/reference/sql-structure/operators/arithmetic-operators/addition-operator) | Addition operator | | | [/](https://mariadb.com/docs/server/reference/sql-structure/operators/arithmetic-operators/division-operator) | Division operator | | | [\*](https://mariadb.com/docs/server/reference/sql-structure/operators/arithmetic-operators/multiplication-operator) | Multiplication operator | | | [%](https://mariadb.com/docs/server/reference/sql-structure/operators/arithmetic-operators/modulo-operator) | Modulo operator. Returns the remainder of N divided by M | | | [-](https://mariadb.com/docs/server/reference/sql-structure/operators/arithmetic-operators/subtraction-operator) | Subtraction operator | | | [!=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/not-equal) | Not equals | | | [<](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/less-than) | Less than | | | [<=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/less-than-or-equal) | Less than or equal | | | [<=>](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/null-safe-equal) | NULL-safe equal | | | [=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/equal) | Equal | | | [>](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/greater-than) | Greater than | | | [>=](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/greater-than-or-equal) | Greater than or equal | | | [&](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/bitwise_and) | Bitwise AND | | | [<<](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/shift-left) | Shift left | | | [>>](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/shift-right) | Shift right | | | [^](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/bitwise-xor) | Bitwise XOR | | | [!](https://mariadb.com/docs/server/reference/sql-structure/operators/logical-operators/not) | Logical NOT | | | [&&](https://mariadb.com/docs/server/reference/sql-structure/operators/logical-operators/and) | Logical AND | | | [XOR](https://mariadb.com/docs/server/reference/sql-structure/operators/logical-operators/xor) | Logical XOR | | | \| | [Bitwise OR](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/bitwise-or) | | | [:=](https://mariadb.com/docs/server/reference/sql-structure/operators/assignment-operators/assignment-operator) | Assignment operator | | | [=](https://mariadb.com/docs/server/reference/sql-structure/operators/assignment-operators/assignment-operators-assignment-operator) | Assignment and comparison operator | | | \~ | [Bitwise NOT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/bitwise-not) | | | [ABS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/abs) | Returns an absolute value | | | [ACOS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/acos) | Returns an arc cosine | | | [ADD\_MONTHS](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/add_months) | Add months to a date | | | [ADDDATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/adddate) | Add days or another interval to a date | | | [ADDTIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/addtime) | Adds a time to a time or datetime | | | [AES\_DECRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/aes_decrypt) | Decryption data encrypted with AES\_ENCRYPT | | | [AES\_ENCRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/aes_encrypt) | Encrypts a string with the AES algorithm | | | [AREA](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_area) | Synonym for ST\_AREA | | | [AsBinary](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_asbinary) | Synonym for ST\_AsBinary | | | [ASCII](https://mariadb.com/docs/server/reference/sql-functions/string-functions/ascii) | Numeric ASCII value of leftmost character | | | [ASIN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/asin) | Returns the arc sine | | | [AsText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_astext) | Synonym for ST\_AsText | | | [AsWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/aswkb) | Synonym for ST\_AsBinary | | | [AsWKT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_aswkt) | Synonym for ST\_AsText | | | [ATAN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/atan) | Returns the arc tangent | | | [ATAN2](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/atan2) | Returns the arc tangent of two variables | | | [AVG](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/avg) | Returns the average value | | | [BENCHMARK](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/benchmark) | Executes an expression repeatedly | | | [BETWEEN AND](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/between-and) | True if expression between two values | | | [BIN](https://mariadb.com/docs/server/reference/sql-functions/string-functions/bin) | Returns binary value | | | [BINARY OPERATOR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/binary-operator) | Casts to a binary string | | | [BINLOG\_GTID\_POS](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/binlog_gtid_pos) | Returns a string representation of the corresponding GTID position | | | [BIT\_AND](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/bit_and) | Bitwise AND | | | [BIT\_COUNT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/bit-functions-and-operators/bit_count) | Returns the number of set bits | | | [BIT\_LENGTH](https://mariadb.com/docs/server/reference/sql-functions/string-functions/bit_length) | Returns the length of a string in bits | | | [BIT\_OR](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/bit_or) | Bitwise OR | | | [BIT\_XOR](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/bit_xor) | Bitwise XOR | | | [BOUNDARY](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_boundary) | Synonym for ST\_BOUNDARY | | | [BUFFER](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/buffer) | Synonym for ST\_BUFFER | | | [CASE](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/case-operator) | Returns the result where value=compare\_value or for the first condition that is true | | | [CAST](https://mariadb.com/docs/server/reference/sql-functions/string-functions/cast) | Casts a value of one type to another type | | | [CEIL](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/ceil) | Synonym for CEILING() | | | [CEILING](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/ceiling) | Returns the smallest integer not less than X | | | [CENTROID](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/centroid) | Synonym for ST\_CENTROID | | | [CHAR Function](https://mariadb.com/docs/server/reference/sql-functions/string-functions/char-function) | Returns string based on the integer values for the individual characters | | | [CHARACTER\_LENGTH](https://mariadb.com/docs/server/reference/sql-functions/string-functions/character_length) | Synonym for CHAR\_LENGTH() | | | [CHAR\_LENGTH](https://mariadb.com/docs/server/reference/sql-functions/string-functions/char_length) | Length of the string in characters | | | [CHARSET](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/charset) | Returns the character set | | | [CHR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/chr) | Returns a string consisting of the character given by the code values of the integer | | | [COALESCE](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/coalesce) | Returns the first non-NULL parameter | | | [COERCIBILITY](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/coercibility) | Returns the collation coercibility value | | | [COLLATION](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/collation) | Collation of the string argument | | | [COLUMN\_ADD](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_add) | Adds or updates dynamic columns | | | [COLUMN\_CHECK](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_check) | Checks if a dynamic column blob is valid | | | [COLUMN\_CREATE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_create) | Returns a dynamic columns blob | | | [COLUMN\_DELETE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_delete) | Deletes a dynamic column | | | [COLUMN\_EXISTS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_exists) | Checks is a column exists | | | [COLUMN\_GET](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_get) | Gets a dynamic column value by name | | | [COLUMN\_JSON](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_json) | Returns a JSON representation of dynamic column blob data | | | [COLUMN\_LIST](https://mariadb.com/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_list) | Returns comma-separated list | | | [COMPRESS](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/compress) | Returns a binary, compressed string | | | [CONCAT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/concat) | Returns concatenated string | | | [CONCAT\_WS](https://mariadb.com/docs/server/reference/sql-functions/string-functions/concat_ws) | Concatenate with separator | | | [CONNECTION\_ID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/connection_id) | Connection thread ID | | | [CONTAINS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/contains) | Whether one geometry contains another | | | [CONVERT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/convert) | Convert a value from one type to another type | | | [CONV](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/conv) | Converts numbers between different number bases | | | [CONVERT\_TZ](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/convert_tz) | Converts a datetime from on time zone to another | | | [CONVEXHULL](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/convexhull) | Synonym for ST\_CONVEXHULL | | | [COS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/cos) | Returns the cosine | | | [COT](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/cot) | Returns the cotangent | | | [COUNT](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/count) | Returns count of non-null values | | | [COUNT DISTINCT](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/count-distinct) | Returns count of number of different non-NULL values | | | [CRC32](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/crc32) | Computes a cyclic redundancy check value | | | [CRC32C](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/crc32c) | Computes a cyclic redundancy check value | [MariaDB 10.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.8/what-is-mariadb-108) | | [CROSSES](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/crosses) | Whether two geometries spatially cross | | | [CUME\_DIST](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/cume_dist) | Window function that returns the cumulative distribution of a given row | | | [CURDATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/curdate) | Returns the current date | | | [CURRENT\_DATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/current_date) | Synonym for CURDATE() | | | [CURRENT\_ROLE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/current_role) | Current role name | | | [CURRENT\_TIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/current_time) | Synonym for CURTIME() | | | [CURRENT\_TIMESTAMP](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/current_timestamp) | Synonym for NOW() | | | [CURRENT\_USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/current_user) | Username/host that authenicated the current client | | | [CURTIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/curtime) | Returns the current time | | | [DATABASE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/database) | Current default database | | | [DATE FUNCTION](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/date-function) | Extracts the date portion of a datetime | | | [DATEDIFF](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/datediff) | Difference in days between two date/time values | | | [DATE\_ADD](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/date_add) | Date arithmetic - addition | | | [DATE\_FORMAT](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/date_format) | Formats the date value according to the format string | | | [DATE\_SUB](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/date_sub) | Date arithmetic - subtraction | | | [DAY](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/day) | Synonym for DAYOFMONTH() | | | [DAYNAME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/dayname) | Return the name of the weekday | | | [DAYOFMONTH](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/dayofmonth) | Returns the day of the month | | | [DAYOFWEEK](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/dayofweek) | Returns the day of the week index | | | [DAYOFYEAR](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/dayofyear) | Returns the day of the year | | | [DECODE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/decode) | Decrypts a string encoded with ENCODE() | | | [DECODE\_HISTOGRAM](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/decode_histogram) | Returns comma separated numerics corresponding to a probability distribution represented by a histogram | | | [DEFAULT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/default) | Returns column default | | | [DEGREES](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/degrees) | Converts from radians to degrees | | | [DENSE\_RANK](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/dense_rank) | Rank of a given row with identical values receiving the same result, no skipping | | | [DES\_DECRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/des_decrypt) | Decrypts a string encrypted with DES\_ENCRYPT() | | | [DES\_ENCRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/des_encrypt) | Encrypts a string using the Triple-DES algorithm | | | [DIMENSION](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/dimension) | Synonym for ST\_DIMENSION | | | [DISJOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/disjoint) | Whether the two elements do not intersect | | | [DIV](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/div) | Integer division | | | [ELT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/elt) | Returns the N'th element from a set of strings | | | [ENCODE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/encode) | Encrypts a string | | | [ENCRYPT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/encrypt) | Encrypts a string with Unix crypt() | | | [ENDPOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_endpoint) | Synonym for ST\_ENDPOINT | | | [ENVELOPE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_envelope) | Synonym for ST\_ENVELOPE | | | [EQUALS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/equals) | Indicates whether two geometries are spatially equal | | | [EXP](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/exp) | e raised to the power of the argument | | | [EXPORT\_SET](https://mariadb.com/docs/server/reference/sql-functions/string-functions/export_set) | Returns an on string for every bit set, an off string for every bit not set | | | [ExteriorRing](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_exteriorring) | Synonym for ST\_ExteriorRing | | | [EXTRACT](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/extract) | Extracts a portion of the date | | | [EXTRACTVALUE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/extractvalue) | Returns the text of the first text node matched by the XPath expression | | | [FIELD](https://mariadb.com/docs/server/reference/sql-functions/string-functions/field) | Returns the index position of a string in a list | | | [FIND\_IN\_SET](https://mariadb.com/docs/server/reference/sql-functions/string-functions/find_in_set) | Returns the position of a string in a set of strings | | | [FLOOR](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/floor) | Largest integer value not greater than the argument | | | [FORMAT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/format) | Formats a number | | | [FORMAT\_BYTES](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/miscellaneous-functions-format_bytes) | Given a byte count, returns a string consisting of a value and the units in a human-readable format. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [FORMAT\_PICO\_TIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/format_pico_time) | Given a time in picoseconds, returns a human-readable time value and unit indicator | [MariaDB 11.0.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.0/11.0.2) | | [FOUND\_ROWS](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/found_rows) | Number of (potentially) returned rows | | | [FROM\_BASE64](https://mariadb.com/docs/server/reference/sql-functions/string-functions/from_base64) | Given a base-64 encoded string, returns the decoded result as a binary string | | | [FROM\_DAYS](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/from_days) | Returns a date given a day | | | [FROM\_UNIXTIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/from_unixtime) | Returns a datetime from a Unix timestamp | | | [GeomCollFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomcollfromtext) | Synonym for ST\_GeomCollFromText | | | [GeomCollFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomcollfromwkb) | Synonym for ST\_GeomCollFromWKB | | | [GEOMETRYCOLLECTION](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/geometrycollection) | Constructs a WKB GeometryCollection | | | [GeometryCollectionFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/geometrycollectionfromtext) | Synonym for ST\_GeomCollFromText | | | [GeometryCollectionFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/geometrycollectionfromwkb) | Synonym for ST\_GeomCollFromWKB | | | [GeometryFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/geometryfromtext) | Synonym for ST\_GeomFromText | | | [GeometryFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/geometryfromwkb) | Synonym for ST\_GeomFromWKB | | | [GeomFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [GeomFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [GeometryN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_geometryn) | Synonym for ST\_GeometryN | | | [GeometryType](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_geometrytype) | Synonym for ST\_GeometryType | | | [GET\_FORMAT](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/get_format) | Returns a format string | | | [GET\_LOCK](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/get_lock) | Obtain LOCK | | | [GLENGTH](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/glength) | Length of a LineString value | | | [GREATEST](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/greatest) | Returns the largest argument | | | [GROUP\_CONCAT](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/group_concat) | Returns string with concatenated values from a group | | | [HEX](https://mariadb.com/docs/server/reference/sql-functions/string-functions/hex) | Returns hexadecimal value | | | [HOUR](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/hour) | Returns the hour | | | [IF](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/if-function) | If expr1 is TRUE, returns expr2; otherwise returns expr3 | | | [IFNULL](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/ifnull) | Check whether an expression is NULL | | | [IN](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/in) | True if expression equals any of the values in the list | | | [INTERVAL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/interval) | Index of the argument that is less than the first argument | | | [INET6\_ATON](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/inet6_aton) | Given an IPv6 or IPv4 network address, returns a VARBINARY numeric value | | | [INET6\_NTOA](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/inet6_ntoa) | Given an IPv6 or IPv4 network address, returns the address as a nonbinary string | | | [INET\_ATON](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/inet_aton) | Returns numeric value of IPv4 address | | | [INET\_NTOA](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/inet_ntoa) | Returns dotted-quad representation of IPv4 address | | | [INSERT Function](https://mariadb.com/docs/server/reference/sql-functions/string-functions/insert-function) | Replaces a part of a string with another string | | | [INSTR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/instr) | Returns the position of a string withing a string | | | [InteriorRingN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_interiorringn) | Synonym for ST\_InteriorRingN | | | [INTERSECTS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/intersects) | Indicates whether two geometries spatially intersect | | | [IS](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is) | Tests whether a boolean is TRUE, FALSE, or UNKNOWN | | | [IsClosed](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/isclosed) | Synonym for ST\_IsClosed | | | [IsEmpty](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_isempty) | Synonym for ST\_IsEmpty | | | [IS\_FREE\_LOCK](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/is_free_lock) | Checks whether lock is free to use | | | [IS\_IPV4](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/is_ipv4) | Whether or not an expression is a valid IPv4 address | | | [IS\_IPV4\_COMPAT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/is_ipv4_compat) | Whether or not an IPv6 address is IPv4-compatible | | | [IS\_IPV4\_MAPPED](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/is_ipv4_mapped) | Whether an IPv6 address is a valid IPv4-mapped address | | | [IS\_IPV6](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/is_ipv6) | Whether or not an expression is a valid IPv6 address | | | [IS NOT](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-not) | Tests whether a boolean value is not TRUE, FALSE, or UNKNOWN | | | [IS NOT NULL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-not-null) | Tests whether a value is not NULL | | | [IS NULL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/is-null) | Tests whether a value is NULL | | | [ISNULL](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/isnull) | Checks if an expression is NULL | | | [IsRing](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/isring) | Synonym for ST\_IsRing | | | [IsSimple](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/geometry-properties-issimple) | Synonym for ST\_IsSimple | | | [IS\_USED\_LOCK](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/is_used_lock) | Check if lock is in use | | | [JSON\_ARRAY](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_array) | Returns a JSON array containing the listed values | | | [JSON\_ARRAYAGG](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/json_arrayagg) | Returns a JSON array containing an element for each value in a given set of JSON or SQL values. | | | [JSON\_ARRAY\_INTERSECT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_array_intersect) | | [MariaDB 11.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/11.2.0) | | [JSON\_ARRAY\_APPEND](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_array_append) | Appends values to the end of the given arrays within a JSON document | | | [JSON\_ARRAY\_INSERT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_array_insert) | Inserts a value into a JSON document | | | [JSON\_COMPACT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_compact) | Removes all unnecessary spaces so the json document is as short as possible | | | [JSON\_CONTAINS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_contains) | Whether a value is found in a given JSON document or at a specified path within the document | | | [JSON\_CONTAINS\_PATH](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_contains_path) | Indicates whether the given JSON document contains data at the specified path or paths | | | [JSON\_DEPTH](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_depth) | Maximum depth of a JSON document | | | [JSON\_DETAILED](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_detailed) | Represents JSON in the most understandable way emphasizing nested structures | | | [JSON\_EQUALS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_equals) | Check for equality between JSON objects. | [MariaDB 10.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.7/what-is-mariadb-107) | | [JSON\_EXISTS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_exists) | Determines whether a specified JSON value exists in the given data | | | [JSON\_EXTRACT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_extract) | Extracts data from a JSON document. | | | [JSON\_INSERT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_insert) | Inserts data into a JSON document | | | [JSON\_KEY\_VALUE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_key_value) | Extracts key/value pairs from a JSON object | [MariaDB 11.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/what-is-mariadb-112) | | [JSON\_KEYS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_keys) | Returns keys from top-level value of a JSON object or top-level keys from the path | | | [JSON\_LENGTH](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_length) | Returns the length of a JSON document, or the length of a value within the document | | | [JSON\_LOOSE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_loose) | Adds spaces to a JSON document to make it look more readable | | | [JSON\_MERGE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_merge) | Merges the given JSON documents | | | [JSON\_MERGE\_PATCH](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_merge) | RFC 7396-compliant merge of the given JSON documents | | | [JSON\_MERGE\_PRESERVE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_merge) | Synonym for [JSON\_MERGE\_PATCH](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_merge). | | | [JSON\_NORMALIZE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_normalize) | Recursively sorts keys and removes spaces, allowing comparison of json documents for equality | | | [JSON\_OBJECT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_object) | Returns a JSON object containing the given key/value pairs | | | [JSON\_OBJECT\_FILTER\_KEYS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_object_filter_keys) | | [MariaDB 11.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/11.2.0) | | [JSON\_OBJECT\_TO\_ARRAY](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_object_to_array) | | [MariaDB 11.2.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.2/11.2.0) | | [JSON\_OBJECTAGG](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/json_objectagg) | Returns a JSON object containing key-value pairs | | | [JSON\_OVERLAPS](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_overlaps) | Compares two json documents for overlaps | [MariaDB 10.9](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.9/what-is-mariadb-109) | | [JSON\_PRETTY](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_pretty) | Alias for [json\_detailed](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_detailed) | [MariaDB 10.10.3](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.10/10.10.3), [MariaDB 10.9.5](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.9/10.9.5), [MariaDB 10.8.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.8/10.8.7), [MariaDB 10.7.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/10.7/10.7.8), [MariaDB 10.6.12](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/changelogs/10.6/10.6.12) | | [JSON\_QUERY](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_query) | Given a JSON document, returns an object or array specified by the path | | | [JSON\_QUOTE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_quote) | Quotes a string as a JSON value | | | [JSON\_REMOVE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_remove) | Removes data from a JSON document | | | [JSON\_REPLACE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_replace) | Replaces existing values in a JSON document | | | [JSON\_SCHEMA\_VALID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_schema_valid) | Validates a JSON schema | [MariaDB 11.1.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.1/11.1.0) | | [JSON\_SEARCH](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_search) | Returns the path to the given string within a JSON document | | | [JSON\_SET](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_set) | Updates or inserts data into a JSON document | | | [JSON\_TABLE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_table) | Returns a representation of a JSON document as a relational table | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [JSON\_TYPE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_type) | Returns the type of a JSON value | | | [JSON\_UNQUOTE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_unquote) | Unquotes a JSON value, returning a string | | | [JSON\_VALID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_valid) | Whether a value is a valid JSON document or not | | | [JSON\_VALUE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_value) | Given a JSON document, returns the specified scalar | | | [KDF](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/kdf) | Key derivation function | [MariaDB 11.3.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.3/11.3.0) | | [LAST\_DAY](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/last_day) | Returns the last day of the month | | | [LAST\_INSERT\_ID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/last_insert_id) | Last inserted autoinc value | | | [LAST\_VALUE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/last_value) | Returns the last value in a list | | | [LASTVAL](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/previous-value-for-sequence_name) | Get last value generated from a sequence | | | [LCASE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/lcase) | Synonym for \[LOWER() | | | [LEAST](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/least) | Returns the smallest argument | | | [LEFT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/left) | Returns the leftmost characters from a string | | | [LENGTH](https://mariadb.com/docs/server/reference/sql-functions/string-functions/length) | Length of the string in bytes | | | [LIKE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/like) | Whether expression matches a pattern | | | [LineFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_linefromtext) | Synonym for ST\_LineFromText | | | [LineFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_linefromwkb) | Synonym for ST\_LineFromWKB | | | [LINESTRING](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/linestring) | Constructs a WKB LineString value from a number of WKB Point arguments | | | [LineStringFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/linestringfromtext) | Synonym for ST\_LineFromText | | | [LineStringFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/linestringfromwkb) | Synonym for ST\_LineFromWKB | | | [LN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/ln) | Returns natural logarithm | | | [LOAD\_FILE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/load_file) | Returns file contents as a string | | | [LOCALTIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/localtime) | Synonym for NOW() | | | [LOCALTIMESTAMP](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/localtimestamp) | Synonym for NOW() | | | [LOCATE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/locate) | Returns the position of a substring in a string | | | [LOG](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/log) | Returns the natural logarithm | | | [LOG10](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/log10) | Returns the base-10 logarithm | | | [LOG2](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/log2) | Returns the base-2 logarithm | | | [LOWER](https://mariadb.com/docs/server/reference/sql-functions/string-functions/lower) | Returns a string with all characters changed to lowercase | | | [LPAD](https://mariadb.com/docs/server/reference/sql-functions/string-functions/lpad) | Returns the string left-padded with another string to a given length | | | [LTRIM](https://mariadb.com/docs/server/reference/sql-functions/string-functions/ltrim) | Returns the string with leading space characters removed | | | [MAKE\_SET](https://mariadb.com/docs/server/reference/sql-functions/string-functions/make_set) | Make a set of strings that matches a bitmask | | | [MAKEDATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/makedate) | Returns a date given a year and day | | | [MAKETIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/maketime) | Returns a time | | | [MASTER\_GTID\_WAIT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/master_gtid_wait) | Wait until slave reaches the GTID position | | | [MASTER\_POS\_WAIT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/master_pos_wait) | Blocks until the slave has applied all specified updates | | | [MATCH AGAINST](https://mariadb.com/docs/server/reference/sql-functions/string-functions/match-against) | Perform a fulltext search on a fulltext index | | | [MAX](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/max) | Returns the maximum value | | | [MBRContains](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrcontains) | Whether one Minimum Bounding Rectangle contains another. | | | [MBRCoveredBy](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrcoveredby) | Whether one Minimum Bounding Rectangle is covered by another. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [MBRDisjoint](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrdisjoint) | Whether the Minimum Bounding Rectangles of two geometries are disjoint | | | [MBREqual](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrequal) | Whether the Minimum Bounding Rectangles of two geometries are the same. | | | [MBREquals](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrequal) | Synonym for MBREqual. | | | [MBRIntersects](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrintersects) | Indicates whether the Minimum Bounding Rectangles of the two geometries intersect | | | [MBROverlaps](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbroverlaps) | Whether the Minimum Bounding Rectangles of two geometries overlap | | | [MBRTouches](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrtouches) | Whether the Minimum Bounding Rectangles of two geometries touch. | | | [MBRWithin](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/mbr-minimum-bounding-rectangle/mbrwithin) | Indicates whether one Minimum Bounding Rectangle is within another | | | [MD5](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/md5) | MD5 checksum | | | [MEDIAN](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/median) | Window function that returns the median value of a range of values | | | [MICROSECOND](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/microsecond) | Returns microseconds from a date or datetime | | | [MID](https://mariadb.com/docs/server/reference/sql-functions/string-functions/mid) | Synonym for SUBSTRING(str,pos,len) | | | [MIN](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/min) | Returns the minimum value | | | [MINUTE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/minute) | Returns a minute from 0 to 59 | | | [MLineFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/mlinefromtext) | Constructs MULTILINESTRING using its WKT representation and SRID | | | [MLineFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/mlinefromwkb) | Constructs a MULTILINESTRING | | | [MOD](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/mod) | Modulo operation. Remainder of N divided by M | | | [MONTH](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/month) | Returns a month from 1 to 12 | | | [MONTHNAME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/monthname) | Returns the full name of the month | | | [MPointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/mpointfromtext) | Constructs a MULTIPOINT value using its WKT and SRID | | | [MPointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/mpointfromwkb) | Constructs a MULTIPOINT value using its WKB representation and SRID | | | [MPolyFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/mpolyfromtext) | Constructs a MULTIPOLYGON value | | | [MPolyFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/mpolyfromwkb) | Constructs a MULTIPOLYGON value using its WKB representation and SRID | | | [MULTILINESTRING](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/multilinestring) | Constructs a MultiLineString value | | | [MultiLineStringFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/multilinestringfromtext) | Synonym for MLineFromText | | | [MultiLineStringFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/multilinestringfromwkb) | A synonym for MLineFromWKB | | | [MULTIPOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/multipoint) | Constructs a WKB MultiPoint value | | | [MultiPointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/multipointfromtext) | Synonym for MPointFromText | | | [MultiPointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/multipointfromwkb) | Synonym for MPointFromWKB | | | [MULTIPOLYGON](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/multipolygon) | Constructs a WKB MultiPolygon | | | [MultiPolygonFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/multipolygonfromtext) | Synonym for MPolyFromText | | | [MultiPolygonFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/multipolygonfromwkb) | Synonym for MPolyFromWKB | | | [NAME\_CONST](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/name_const) | Returns the given value | | | [NATURAL\_SORT\_KEY](https://mariadb.com/docs/server/reference/sql-functions/string-functions/natural_sort_key) | Sorting that is more similar to natural human sorting | | | [NOT LIKE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/not-like) | Same as NOT(expr LIKE pat \[ESCAPE 'escape\_char']) | | | [NOT REGEXP](https://mariadb.com/docs/server/reference/sql-functions/string-functions/not-regexp) | Same as NOT (expr REGEXP pat) | | | [NULLIF](https://mariadb.com/docs/server/reference/sql-functions/control-flow-functions/nullif) | Returns NULL if expr1 = expr2 | | | [NEXTVAL](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/next-value-for-sequence_name) | Generate next value for sequence | | | [NOT BETWEEN](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/not-between) | Same as NOT (expr BETWEEN min AND max) | | | [NOT IN](https://mariadb.com/docs/server/reference/sql-structure/operators/comparison-operators/not-in) | Same as NOT (expr IN (value,...)) | | | [NOW](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/now) | Returns the current date and time | | | [NTILE](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/ntile) | Returns an integer indicating which group a given row falls into | | | [NumGeometries](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_numgeometries) | Synonym for ST\_NumGeometries | | | [NumInteriorRings](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_numinteriorrings) | Synonym for NumInteriorRings | | | [NumPoints](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_numpoints) | Synonym for ST\_NumPoints | | | [OCT](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/oct) | Returns octal value | | | [OCTET\_LENGTH](https://mariadb.com/docs/server/reference/sql-functions/string-functions/octet_length) | Synonym for LENGTH() | | | [OLD\_PASSWORD](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/old_password) | Pre MySQL 4.1 password implementation | | | [ORD](https://mariadb.com/docs/server/reference/sql-functions/string-functions/ord) | Return ASCII or character code | | | [OVERLAPS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/overlaps) | Indicates whether two elements spatially overlap | | | [PASSWORD](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/password) | Calculates a password string | | | [PERCENT\_RANK](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/percent_rank) | Window function that returns the relative percent rank of a given row | | | [PERCENTILE\_CONT](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/percentile_cont) | Returns a value which corresponds to the given fraction in the sort order. | | | [PERCENTILE\_DISC](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/percentile_disc) | Returns the first value in the set whose ordered position is the same or more than the specified fraction. | | | [PERIOD\_ADD](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/period_add) | Add months to a period | | | [PERIOD\_DIFF](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/period_diff) | Number of months between two periods | | | [PI](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/pi) | Returns the value of π (pi) | | | [POINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/point) | Constructs a WKB Point | | | [PointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_pointfromtext) | Synonym for ST\_PointFromText | | | [PointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_pointfromwkb) | Synonym for PointFromWKB | | | [PointN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_pointn) | Synonym for PointN | | | [PointOnSurface](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/pointonsurface) | Synonym for ST\_PointOnSurface | | | [POLYGON](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/polygon) | Constructs a WKB Polygon value from a number of WKB LineString arguments | | | [PolyFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_polyfromtext) | Synonym for ST\_PolyFromText | | | [PolyFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_polyfromwkb) | Synonym for ST\_PolyFromWKB | | | [PolygonFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/polygonfromtext) | Synonym for ST\_PolyFromText | | | [PolygonFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/polygonfromwkb) | Synonym for ST\_PolyFromWKB | | | [POSITION](https://mariadb.com/docs/server/reference/sql-functions/string-functions/position) | Returns the position of a substring in a string | | | [POW](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/pow) | Returns X raised to the power of Y | | | [POWER](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/power) | Synonym for POW() | | | [QUARTER](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/quarter) | Returns year quarter from 1 to 4 | | | [QUOTE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/quote) | Returns quoted, properly escaped string | | | [RADIANS](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/radians) | Converts from degrees to radians | | | [RAND](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/rand) | Random floating-point value | | | [RANK](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/rank) | Rank of a given row with identical values receiving the same result | | | [REGEXP](https://mariadb.com/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp) | Performs pattern matching | | | [REGEXP\_INSTR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_instr) | Position of the first appearance of a regex | | | [REGEXP\_REPLACE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_replace) | Replaces all occurrences of a pattern | | | [REGEXP\_SUBSTR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_substr) | Returns the matching part of a string | | | [RELEASE\_LOCK](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/release_lock) | Releases lock obtained with GET\_LOCK() | | | [REPEAT Function](https://mariadb.com/docs/server/reference/sql-functions/string-functions/repeat-function) | Returns a string repeated a number of times | | | [REPLACE Function](https://mariadb.com/docs/server/reference/sql-functions/string-functions/replace-function) | Replace occurrences of a string | | | [REVERSE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/reverse) | Reverses the order of a string | | | [RIGHT](https://mariadb.com/docs/server/reference/sql-functions/string-functions/right) | Returns the rightmost N characters from a string | | | [RLIKE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/rlike) | Synonym for REGEXP() | | | [RPAD](https://mariadb.com/docs/server/reference/sql-functions/string-functions/rpad) | Returns the string right-padded with another string to a given length | | | [ROUND](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/round) | Rounds a number | | | [ROW\_COUNT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/row_count) | Number of rows affected by previous statement | | | [ROW\_NUMBER](https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/row_number) | Row number of a given row with identical values receiving a different result | | | [RTRIM](https://mariadb.com/docs/server/reference/sql-functions/string-functions/rtrim) | Returns the string with trailing space characters removed | | | [SCHEMA](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/schema) | Synonym for DATABASE() | | | [SECOND](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/second) | Returns the second of a time | | | [SEC\_TO\_TIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/sec_to_time) | Converts a second to a time | | | [SETVAL](https://mariadb.com/docs/server/reference/sql-structure/sequences/sequence-functions/setval) | Set the next value to be returned by a sequence | | | [SESSION\_USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/session_user) | Synonym for USER() | | | [sha](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/sha1) | Synonym for SHA1() | | | [SHA1](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/sha1) | Calculates an SHA-1 checksum | | | [SHA2](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/sha2) | Calculates an SHA-2 checksum | | | [SIGN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/sign) | Returns 1, 0 or -1 | | | [SIN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/sin) | Returns the sine | | | [SLEEP](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/sleep) | Pauses for the given number of seconds | | | [SOUNDEX](https://mariadb.com/docs/server/reference/sql-functions/string-functions/soundex) | Returns a string based on how the string sounds | | | [SOUNDS LIKE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/sounds-like) | SOUNDEX(expr1) = SOUNDEX(expr2) | | | [SPACE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/space) | Returns a string of space characters | | | [SPIDER\_BG\_DIRECT\_SQL](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-functions/spider_bg_direct_sql) | Background SQL execution | | | [SPIDER\_COPY\_TABLES](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-functions/spider_copy_tables) | Copy table data | | | [SPIDER\_DIRECT\_SQL](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-functions/spider_direct_sql) | Execute SQL on the remote server | | | [SPIDER\_FLUSH\_TABLE\_MON\_CACHE](https://mariadb.com/docs/server/server-usage/storage-engines/spider/spider-functions/spider_flush_table_mon_cache) | Refreshing Spider monitoring server information | | | [SQRT](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/sqrt) | Square root | | | [SRID](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_srid) | Synonym for ST\_SRID | | | [ST\_AREA](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_area) | Area of a Polygon | | | [ST\_AsBinary](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_asbinary) | Converts a value to its WKB representation | | | [ST\_AsGeoJson](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/geojson-st_asgeojson) | Returns a GeoJSON element from a given geometry. | | | [ST\_AsText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_astext) | Converts a value to its WKT-Definition | | | [ST\_AsWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_aswkb) | Synonym for ST\_AsBinary | | | [ST\_ASWKT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_aswkt) | Synonym for ST\_ASTEXT() | | | [ST\_BOUNDARY](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_boundary) | Returns a geometry that is the closure of a combinatorial boundary | | | [ST\_BUFFER](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_buffer) | A new geometry with a buffer added to the original geometry | | | [ST\_CENTROID](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_centroid) | The mathematical centroid (geometric center) for a MultiPolygon | | | [ST\_Collect](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_collect) | Returns the aggregation of the distinct geometry arguments | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_CONTAINS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-contains) | Whether one geometry is contained by another | | | [ST\_CONVEXHULL](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_convexhull) | The minimum convex geometry enclosing all geometries within the set | | | [ST\_CROSSES](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-crosses) | Whether two geometries spatially cross | | | [ST\_DIFFERENCE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_difference) | Point set difference | | | [ST\_DIMENSION](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_dimension) | Inherent dimension of a geometry value | | | [ST\_DISJOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_disjoint) | Whether one geometry is spatially disjoint from another | | | [ST\_DISTANCE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_distance) | The distance between two geometries | | | [ST\_DISTANCE\_SPHERE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_distance_sphere) | The spherical distance between two geometries | | | [ST\_ENDPOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_endpoint) | Returns the endpoint of a LineString | | | [ST\_ENVELOPE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_envelope) | Returns the Minimum Bounding Rectangle for a geometry value | | | [ST\_EQUALS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-equals) | Whether two geometries are spatoially equal | | | [ST\_ExteriorRing](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_exteriorring) | Returns the exterior ring of a Polygon as a LineString | | | [ST\_GeoHash](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_geohash) | Returns a geohash. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_GeomCollFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomcollfromtext) | Constructs a GEOMETRYCOLLECTION value | | | [ST\_GeomCollFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomcollfromwkb) | Constructs a GEOMETRYCOLLECTION value from a WKB | | | [ST\_GeometryCollectionFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geometrycollectionfromtext) | Synonym for ST\_GeomCollFromText | | | [ST\_GeometryCollectionFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geometrycollectionfromwkb) | Synonym for ST\_GeomCollFromWKB | | | [ST\_GeometryFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geometryfromtext) | Synonym for ST\_GeomFromText | | | [ST\_GeometryFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geometryfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_GEOMETRYN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_geometryn) | Returns the N-th geometry in a GeometryCollection | | | [ST\_GEOMETRYTYPE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_geometrytype) | Returns name of the geometry type of which a given geometry instance is a member | | | [ST\_GeomFromGeoJSON](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_geomfromgeojson) | Returns a geometry object from a GeoJSON input | | | [ST\_GeomFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Constructs a geometry value using its WKT and SRID | | | [ST\_GeomFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Constructs a geometry value using its WKB representation and SRID | | | [ST\_InteriorRingN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_interiorringn) | Returns the N-th interior ring for a Polygon | | | [ST\_INTERSECTION](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_intersection) | The intersection, or shared portion, of two geometries | | | [ST\_INTERSECTS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-intersects) | Whether two geometries spatially intersect | | | [ST\_ISCLOSED](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_isclosed) | Returns true if a given LINESTRING's start and end points are the same | | | [ST\_ISEMPTY](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_isempty) | Indicated validity of geometry value | | | [ST\_IsRing](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_isring) | Returns true if a given LINESTRING is both ST\_IsClosed and ST\_IsSimple | | | [ST\_IsSimple](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_issimple) | Returns true if the given Geometry has no anomalous geometric points | | | [ST\_IsValid](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_isvalid) | Returns 1 if the argument is geometrically valid, 0 if not. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_LatFromGeoHash](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_latfromgeohash) | Returns a latitude from the given geohash. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_LongFromGeoHash](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_longfromgeohash) | Returns a longitude from the given geohash. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_LENGTH](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st_length) | Length of a LineString value | | | [ST\_LineFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_linefromtext) | Creates a linestring value | | | [ST\_LineFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_linefromwkb) | Constructs a LINESTRING using its WKB and SRID | | | [ST\_LineStringFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_linestringfromtext) | Synonym for ST\_LineFromText | | | [ST\_LineStringFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_linestringfromwkb) | Synonym for ST\_LineFromWKB | | | [ST\_MLineFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [ST\_MLineFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_MPointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [ST\_MPointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_MPolyFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [ST\_MPolyFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_MultiLineStringFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [ST\_MultiLineStringFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_MultiPointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [ST\_MultiPolygonFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_geomfromtext) | Synonym for ST\_GeomFromText | | | [ST\_MultiPolygonFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_MultiPointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_geomfromwkb) | Synonym for ST\_GeomFromWKB | | | [ST\_NUMGEOMETRIES](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_numgeometries) | Number of geometries in a GeometryCollection | | | [ST\_NumInteriorRings](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/polygon-properties/st_numinteriorrings) | Number of interior rings in a Polygon | | | [ST\_NUMPOINTS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_numpoints) | Returns the number of Point objects in a LineString | | | [ST\_OVERLAPS](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-overlaps) | Whether two geometries overlap | | | [ST\_PointFromGeoHash](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_pointfromgeohash) | Returns a point from the given geohash. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_PointFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_pointfromtext) | Constructs a POINT value | | | [ST\_PointFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_pointfromwkb) | Constructs POINT using its WKB and SRID | | | [ST\_POINTN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_pointn) | Returns the N-th Point in the LineString | | | [ST\_POINTONSURFACE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_pointonsurface) | Returns a POINT guaranteed to intersect a surface | | | [ST\_PolyFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_polyfromtext) | Constructs a POLYGON value | | | [ST\_PolyFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_polyfromwkb) | Constructs POLYGON value using its WKB representation and SRID | | | [ST\_PolygonFromText](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkt/st_polygonfromtext) | Synonym for ST\_PolyFromText | | | [ST\_PolygonFromWKB](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/wkb/st_polygonfromwkb) | Synonym for ST\_PolyFromWKB | | | [ST\_RELATE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_relate) | Returns true if two geometries are related | | | [ST\_Simplify](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_simplify) | Applies the Ramer–Douglas–Peucker algorithm to provide generalized simplifications. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_SRID](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-properties/st_srid) | Returns a Spatial Reference System ID | | | [ST\_STARTPOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_startpoint) | Returns the start point of a LineString | | | [ST\_SYMDIFFERENCE](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_symdifference) | Portions of two geometries that don't intersect | | | [ST\_TOUCHES](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-touches) | Whether one geometry g1 spatially touches another | | | [ST\_UNION](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-constructors/st_union) | Union of two geometries | | | [ST\_Validate](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_validate) | Whether a geometry is compliant with the WKB format and SRID syntax, and is geometrically valid. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [ST\_WITHIN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/st-within) | Whether one geometry is within another | | | [ST\_X](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/point-properties/st_x) | X-coordinate value for a point | | | [ST\_Y](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/point-properties/st_y) | Y-coordinate for a point | | | [STARTPOINT](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/linestring-properties/st_startpoint) | Synonym for ST\_StartPoint | | | [STD](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/std) | Population standard deviation | | | [STDDEV](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/stddev) | Population standard deviation | | | [STDDEV\_POP](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/stddev_pop) | Returns the population standard deviation | | | [STDDEV\_SAMP](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/stddev_samp) | Standard deviation | | | [STR\_TO\_DATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/str_to_date) | Converts a string to date | | | [STRCMP](https://mariadb.com/docs/server/reference/sql-functions/string-functions/strcmp) | Compares two strings in sort order | | | [SUBDATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/subdate) | Subtract a date unit or number of days | | | [SUBSTR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/substr) | Returns a substring from string starting at a given position | | | [SUBSTRING](https://mariadb.com/docs/server/reference/sql-functions/string-functions/substring) | Returns a substring from string starting at a given position | | | [SUBSTRING\_INDEX](https://mariadb.com/docs/server/reference/sql-functions/string-functions/substring_index) | Returns the substring from string before count occurrences of a delimiter | | | [SUBTIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/subtime) | Subtracts a time from a date/time | | | [SUM](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/sum) | Sum total | | | [SYS.EXTRACT\_SCHEMA\_FROM\_FILE\_NAME](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/extract_schema_from_file_name) | Given a file path, returns the schema (database) name | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.EXTRACT\_TABLE\_FROM\_FILE\_NAME](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/extract_table_from_file_name) | Given a file path, returns the table name | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.FORMAT\_BYTES](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/sys_schema_format_bytes) | Returns a string consisting of a value and the units in a human-readable format | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.FORMAT\_PATH](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_path) | Returns a modified path after replacing subpaths matching the values of various system variables with the variable name | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.FORMAT\_STATEMENT](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_statement) | Returns a reduced length string | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.FORMAT\_TIME](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/format_time) | Returns a human-readable time value and unit indicator | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.LIST\_ADD](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/list_add) | Adds a value to a given list | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.LIST\_DROP](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/list_drop) | Drops a value from a given list | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_IS\_ACCOUNT\_ENABLED](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_account_enabled) | Whether Performance Schema instrumentation for the given account is enabled | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_IS\_CONSUMER\_ENABLED](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_consumer_enabled) | Whether Performance Schema instrumentation for the given consumer is enabled | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_IS\_INSTRUMENT\_DEFAULT\_ENABLED](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_instrument_default_enabled) | Whether a given Performance Schema instrument is enabled by default | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_IS\_INSTRUMENT\_DEFAULT\_TIMED](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_instrument_default_timed) | Returns whether a given Performance Schema instrument is timed by default | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_IS\_THREAD\_INSTRUMENTED](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_is_thread_instrumented) | Returns whether or not Performance Schema instrumentation for the given connection\_id is enabled | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_THREAD\_ACCOUNT](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_account) | Returns the account (username\@hostname) associated with the given thread\_id | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_THREAD\_ID](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_id) | Returns the thread\_id associated with the given connection\_id | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_THREAD\_STACK](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_stack) | Returns all statements, stages, and events within the Performance Schema for a given thread\_id | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.PS\_THREAD\_TRX\_INFO](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/ps_thread_trx_info) | Returns a JSON object with information about the thread specified by the given thread\_id | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.QUOTE\_IDENTIFIER](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/quote_identifier) | Quotes a string to produce a result that can be used as an identifier in an SQL statement | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.SYS\_GET\_CONFIG](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/sys_get_config) | Returns a configuration option value from the sys\_config table | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.VERSION\_MAJOR](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_major) | Returns the MariaDB Server major release version | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.VERSION\_MINOR](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_minor) | Returns the MariaDB Server minor release version | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS.VERSION\_PATCH](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-stored-functions/version_patch) | Returns the MariaDB Server patch release version | [MariaDB 10.6](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/10.6/what-is-mariadb-106) | | [SYS\_GUID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/sys_guid) | Generates a globally unique identifier | | | [SYSDATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/sysdate) | Returns the current date and time | | | [SYSTEM\_USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/system_user) | Synonym for USER() | | | [TAN](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/tan) | Returns the tangent | | | [TIME function](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/time-function) | Extracts the time | | | [TIMEDIFF](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/timediff) | Returns the difference between two date/times | | | [TIMESTAMP FUNCTION](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/timestamp-function) | Return the datetime, or add a time to a date/time | | | [TIMESTAMPADD](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/timestampadd) | Add interval to a date or datetime | | | [TIMESTAMPDIFF](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/timestampdiff) | Difference between two datetimes | | | [TIME\_FORMAT](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/time_format) | Formats the time value according to the format string | | | [TIME\_TO\_SEC](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/time_to_sec) | Returns the time argument, converted to seconds | | | [TO\_BASE64](https://mariadb.com/docs/server/reference/sql-functions/string-functions/to_base64) | Converts a string to its base-64 encoded form | | | [TO\_CHAR](https://mariadb.com/docs/server/reference/sql-functions/string-functions/to_char) | Converts a date/time type to a char | | | [TO\_DAYS](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/to_days) | Number of days since year 0 | | | [TO\_NUMBER](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/to_number) | Converts and expression to [NUMERIC](https://mariadb.com/docs/server/reference/data-types/numeric-data-types/numeric) | [MariaDB 12.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/12.2/mariadb-12.2-changes-and-improvements) | | [TO\_SECONDS](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/to_seconds) | Number of seconds since year 0 | | | [TOUCHES](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/touches) | Whether two geometries spatially touch | | | [TRIM](https://mariadb.com/docs/server/reference/sql-functions/string-functions/trim) | Returns a string with all given prefixes or suffixes removed | | | [TRUNC](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/trunc) | Returns a [DATETIME](https://mariadb.com/docs/server/reference/data-types/date-and-time-data-types/datetime) truncated according to a given format. | [MariaDB 12.2](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/12.2/mariadb-12.2-changes-and-improvements) | | [TRUNCATE](https://mariadb.com/docs/server/reference/sql-functions/numeric-functions/truncate) | Truncates X to D decimal places | | | [UCASE](https://mariadb.com/docs/server/reference/sql-functions/string-functions/ucase) | Synonym for UPPER]]\() | | | [UNHEX](https://mariadb.com/docs/server/reference/sql-functions/string-functions/unhex) | Interprets pairs of hex digits as a number and converts to the character represented by the number | | | [UNCOMPRESS](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/uncompress) | Uncompresses string compressed with COMPRESS() | | | [UNCOMPRESSED\_LENGTH](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/encryption-hashing-and-compression-functions/uncompressed_length) | Returns length of a string before being compressed with COMPRESS() | | | [UNIX\_TIMESTAMP](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/unix_timestamp) | Returns a Unix timestamp | | | [UPDATEXML](https://mariadb.com/docs/server/reference/sql-functions/string-functions/updatexml) | Replace XML | | | [UPPER](https://mariadb.com/docs/server/reference/sql-functions/string-functions/upper) | Changes string to uppercase | | | [USER](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/user) | Current user/host | | | [UTC\_DATE](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/utc_date) | Returns the current UTC date | | | [UTC\_TIME](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/utc_time) | Returns the current UTC time | | | [UTC\_TIMESTAMP](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/utc_timestamp) | Returns the current UTC date and time | | | [UUID](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid) | Returns a Universal Unique Identifier v1 | | | [UUIDv4](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_v4) | Returns a Universal Unique Identifier v4 | [MariaDB 11.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.7/what-is-mariadb-117) | | [UUIDv7](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_v7) | Returns a Universal Unique Identifier v7 | [MariaDB 11.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.7/what-is-mariadb-117) | | [UUID\_SHORT](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/uuid_short) | Return short universal identifier | | | [VALUES or VALUE](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/miscellaneous-functions/values-value) | Refer to columns in INSERT ... ON DUPLICATE KEY UPDATE | | | [VAR\_POP](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/var_pop) | Population standard variance | | | [VAR\_SAMP](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/var_samp) | Returns the sample variance | | | [VARIANCE](https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/variance) | Population standard variance | | | [VEC\_DISTANCE](https://mariadb.com/docs/server/reference/sql-functions/vector-functions/vector-functions-vec_distance) | Calculates either a Euclidean or Cosine distance between two vectors. | [MariaDB 11.8](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/11.8/what-is-mariadb-118) | | [VEC\_DISTANCE\_COSINE](https://mariadb.com/docs/server/reference/sql-functions/vector-functions/vec_distance_cosine) | Calculates a Cosine distance between two vectors. | [MariaDB 11.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.7/what-is-mariadb-117) | | [VEC\_DISTANCE\_EUCLIDEAN](https://mariadb.com/docs/server/reference/sql-functions/vector-functions/vec_distance_euclidean) | Calculates a Euclidean (L2) distance between two points. | [MariaDB 11.7](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.7/what-is-mariadb-117) | | [VEC\_FromText](https://mariadb.com/docs/server/reference/sql-functions/vector-functions/vec_fromtext) | Converts a text representation of the vector to a vector. | [MariaDB 11.6.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.6/11.6.0) Vector | | [VEC\_ToText](https://mariadb.com/docs/server/reference/sql-functions/vector-functions/vec_totext) | Converts a binary vector into a json array of numbers (floats). | [MariaDB 11.6.0](https://app.gitbook.com/s/aEnK0ZXmUbJzqQrTjFyb/community-server/old-releases/11.6/11.6.0) Vector | | [VERSION](https://mariadb.com/docs/server/reference/sql-functions/secondary-functions/information-functions/version) | MariaDB server version | | | [WEEK](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/week) | Returns the week number | | | [WEEKDAY](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/weekday) | Returns the weekday index | | | [WEEKOFYEAR](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/weekofyear) | Returns the calendar week of the date as a number in the range from 1 to 53 | | | [WEIGHT\_STRING](https://mariadb.com/docs/server/reference/sql-functions/string-functions/weight_string) | Weight of the input string | | | [WITHIN](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/geometry-relations/within) | Indicate whether a geographic element is spacially within another | | | [WSREP\_LAST\_SEEN\_GTID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_last_seen_gtid) | Returns the Global Transaction ID of the most recent write transaction observed by the client. | | | [WSREP\_LAST\_WRITTEN\_GTID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_last_written_gtid) | Returns the Global Transaction ID of the most recent write transaction performed by the client. | | | [WSREP\_SYNC\_WAIT\_UPTO\_GTID](https://mariadb.com/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_sync_wait_upto_gtid) | Blocks the client until the transaction specified by the given Global Transaction ID is applied and committed by the node | | | [X](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/point-properties/st_x) | Synonym for ST\_X | | | [Y](https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/point-properties/st_y) | Synonym for ST\_Y | | | [YEAR](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/year) | Returns the year for the given date | | | [YEARWEEK](https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/yearweek) | Returns year and week for a date | | *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}