Functions dealing with strings, such as CHAR, CONVERT, CONCAT, PAD, REGEXP, TRIM, etc.
| Title | Description |
|---|---|
| Regular Expressions Functions | Functions for dealing with regular expressions |
| Dynamic Columns Functions | Functions for storing key/value pairs of data within a column. |
| ASCII | Numeric ASCII value of leftmost character. |
| BIN | Returns binary value. |
| BINARY Operator | Casts to a binary string. |
| BIT_LENGTH | Returns the length of a string in bits. |
| CAST | Casts a value of one type to another type. |
| CHAR Function | Returns string based on the integer values for the individual characters. |
| CHARACTER_LENGTH | Synonym for CHAR_LENGTH(). |
| CHAR_LENGTH | Length of the string in characters. |
| CHR | Returns string based on integer values of the individual characters. |
| CONCAT | Returns concatenated string. |
| CONCAT_WS | Concatenate with separator. |
| CONVERT | Convert a value from one type to another type. |
| ELT | Returns the N'th element from a set of strings. |
| EXPORT_SET | Returns an on string for every bit set, an off string for every bit not set. |
| EXTRACTVALUE | Returns the text of the first text node matched by the XPath expression. |
| FIELD | Returns the index position of a string in a list. |
| FIND_IN_SET | Returns the position of a string in a set of strings. |
| FORMAT | Formats a number. |
| FROM_BASE64 | Given a base-64 encoded string, returns the decoded result as a binary string. |
| HEX | Returns hexadecimal value. |
| INSERT Function | Replaces a part of a string with another string. |
| INSTR | Returns the position of a string within a string. |
| LCASE | Synonym for LOWER(). |
| LEFT | Returns the leftmost characters from a string. |
| LENGTH | Length of the string in bytes. |
| LENGTHB | Synonym for LENGTH(). |
| LIKE | Whether expression matches a pattern. |
| LOAD_FILE | Returns file contents as a string. |
| LOCATE | Returns the position of a substring in a string. |
| LOWER | Returns a string with all characters changed to lowercase. |
| LPAD | Returns the string left-padded with another string to a given length. |
| LTRIM | Returns the string with leading space characters removed. |
| MAKE_SET | Make a set of strings that matches a bitmask. |
| MATCH AGAINST | Perform a fulltext search on a fulltext index. |
| Full-Text Index Stopwords | Default list of full-text stopwords used by MATCH...AGAINST. |
| MID | Synonym for SUBSTRING(str,pos,len). |
| NOT LIKE | Same as NOT(expr LIKE pat [ESCAPE 'escape_char']). |
| NOT REGEXP | Same as NOT (expr REGEXP pat). |
| OCTET_LENGTH | Synonym for LENGTH(). |
| ORD | Return ASCII or character code. |
| POSITION | Returns the position of a substring in a string. |
| QUOTE | Returns quoted, properly escaped string. |
| REPEAT Function | Returns a string repeated a number of times. |
| REPLACE Function | Replace occurrences of a string. |
| REVERSE | Reverses the order of a string. |
| RIGHT | Returns the rightmost N characters from a string. |
| RPAD | Returns the string right-padded with another string to a given length. |
| RTRIM | Returns the string with trailing space characters removed. |
| SOUNDEX | Returns a string based on how the string sounds. |
| SOUNDS LIKE | SOUNDEX(expr1) = SOUNDEX(expr2). |
| SPACE | Returns a string of space characters. |
| STRCMP | Compares two strings in sort order. |
| SUBSTR | Returns a substring from string starting at a given position. |
| SUBSTRING | Returns a substring from string starting at a given position. |
| SUBSTRING_INDEX | Returns the substring from string before count occurrences of a delimiter. |
| TO_BASE64 | Converts a string to its base-64 encoded form. |
| TRIM | Returns a string with all given prefixes or suffixes removed. |
| UCASE | Synonym for UPPER(). |
| UNCOMPRESSED_LENGTH | Returns length of a string before being compressed with COMPRESS(). |
| UNHEX | Interprets pairs of hex digits as numbers and converts to the character represented by the number. |
| UPDATEXML | Replace XML. |
| UPPER | Changes string to uppercase. |
| WEIGHT_STRING | Weight of the input string. |
| Type Conversion | When implicit type conversion takes place. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/string-functions/