MariaDB String Functions

In MariaDB, ASCII() is a built-in string function that returns the ASCII value of the first character of the specified string argument.

In MariaDB, BIN() is a built-in string function that returns the string representation of the binary value of a given number.

In MariaDB, BIT_LENGTH() is a built-in string function that returns the number of bits of the given string argument.

In MariaDB, CHAR_LENGTH() is a built-in string function that returns the number of characters for a given string argument.

In MariaDB, CHAR() is a built-in string function that converts each integer argument to the corresponding character and returns a string consisting of those characters.

In MariaDB, CHARACTER_LENGTH() is a built-in string function that returns the number of characters for a given string argument.

In MariaDB, CHR() is a built-in string function, which converts the specified integer parameter into the corresponding character and returns it.

In MariaDB, COMPRESS() is a built-in function that compresses a string and returns the result as a binary string.

In MariaDB, CONCAT_WS() is a built-in string function that concatenates other string arguments using the specified delimiter and returns the result.

In MariaDB, CONCAT() is a built-in string function that concatenates all argument lists and returns the result.

In MariaDB, ELT() is a built-in string function that searches for the parameter at the position specified by the first parameter starting from the second parameter and returns it as a string.

In MariaDB, EXPORT_SET() is a built-in string function that generates a string using the specified delimiter based on the bits of the argument.

In MariaDB, the FIELD() function returns the position index of a specified value in a given list.

In MariaDB, the FIND_IN_SET() function returns the index position where the given value occurs in the specified string list.

In MariaDB, FORMAT() is a built-in string function that rounds a given number to a specified number of decimal places

In MariaDB, FROM_BASE64() is a built-in string function that decodes a given base-64 encoded string and returns the result as a binary string.

In MariaDB, HEX() is a built-in string function that returns a hexadecimal string representation of its argument.

In MariaDB, INSERT() is a built-in string function that inserts a given string into another string at a specified position.

In MariaDB, the built-in string INSTR() function returns the index of the first occurrence of a substring within a string.

In MariaDB, LCASE() is a built-in string function that converts the given string parameter to lowercase and returns it.

In MariaDB, the LEFT() function extracts a given number of characters from the leftmost side of a string and returns them as a string.

In MariaDB, LENGTH() is a built-in string function, it returns the length of the given string in bytes in default mode and returns the characters number of the string in Oracle mode.

In MariaDB, LENGTHB() is a built-in string function that returns the length of a given string in bytes.

In MariaDB, the LOAD_FILE() function reads a given file and returns the file contents as a string.

In MariaDB, LOCATE() is a built-in string function that returns the index of the first occurrence of a substring within a string.

In MariaDB, LOWER() is a built-in string function that converts the given string parameter to lowercase and returns it.

The MariaDB LPAD() function left pads the given string to the specified length.

In MariaDB, LTRIM_ORACLE() is a built-in string function that returns a string with all the leading whitespace removed.

In MariaDB, LTRIM() is a built-in string function that returns a string with all the leading whitespaces removed.

In MariaDB, MAKE_SET() is a string function that returns a comma-separated string collection，it determines whether other string parameters adds to the result collection by the binary value corresponding to the first parameter.

In MariaDB, MID() is a built-in string function that extracts a substring of a specified length from a string starting from a specified position.

In MariaDB, OCTET_LENGTH() is a built-in string function that returns the length in bytes of the given string argument.

In MariaDB, ORD() is a built-in string function that returns the numeric code of the first character in a string argument.

In MariaDB, POSITION() is a built-in string function that returns the position of the first occurrence of a substring within a string.

In MariaDB, QUOTE() is a built-in string function that returns a string enclosed in single quotes so that it is suitable for inclusion in an SQL statement.

In MariaDB, the REGEXP_INSTR() function searches a string for a substring that matches the specified pattern and returns the position index of the substring.

In MariaDB, the REGEXP_REPLACE() function replaces a substring matching the specified regular expression with the new content.

In MariaDB, the REGEXP_SUBSTR() function returns the substring matching the specified regular expression from a string.

In MariaDB, REPEAT() is a built-in string function that repeats the specified string for the specified number of times and returns it.

In MariaDB, REPLACE() is a built-in string function that will replace all occurrences of a substring in a string with a new substring.

In MariaDB, REVERSE() is a built-in string function that reverses the given string and returns it.

In MariaDB, the RIGHT() function extracts a given number of characters from the rightmost part of a string and returns it.

The MariaDB RPAD() function right pads the given string to the specified length.

In MariaDB, RTRIM_ORACLE() is a built-in string function that returns a string with all the trailing whitespaces removed.

In MariaDB, RTRIM() is a built-in string function that returns a string with all the trailing whitespaces removed.

In MariaDB, SOUNDEX() is a built-in string function that returns a soundex string representing the pronunciation of a given string.

In MariaDB, you can use SOUNDS LIKE to compare whether two words are pronounced the same.

In MariaDB, SPACE() is a built-in string function that returns a string consisting of a specified number of spaces.

In MariaDB, STRCMP() is a built-in string function that compares two strings and returns 0, -1 or 1 as the result of the comparison.

In MariaDB, SUBSTR() is a built-in string function that returns a substring of a specified length from a string starting at a specified position.

In MariaDB, SUBSTRING_INDEX() is a built-in string function that returns the substring of the specified number of occurrences of the specified delimiter.

In MariaDB, SUBSTRING() is a built-in string function that returns a substring of a specified length from a string starting at a specified position.

In MariaDB, TO_BASE64() is a built-in string function that converts its string argument to its base-64 encoded form.

In MariaDB, TO_CHAR() is a built-in string function that converts a given date/time value to a string in a given format.

In MariaDB, TRIM_ORACLE() is a built-in string function that removes the longest string consisting of specified characters from the beginning or end of a specified string.

In MariaDB, TRIM() is a built-in string function that removes the longest string consisting of specified characters from the beginning or end of a specified string.

In MariaDB, UCASE() is a built-in string function that converts the given string argument to uppercase and returns the result.

In MariaDB, UNCOMPRESS() is a built-in function that decompresses strings compressed by the COMPRESS() function.

In MariaDB, UNCOMPRESSED_LENGTH() is a built-in function that returns the length in bytes of a string before being compressed by the COMPRESS() function.

In MariaDB, UNHEX() is a built-in string function that converts a string representing a hexadecimal value to bytes and returns the corresponding binary string.

In MariaDB, UPPER() is a built-in string function that converts the given string argument to uppercase and returns the result.

In MariaDB, WEIGHT_STRING() is a built-in function that returns a binary string representing the comparison and sort weights of the input strings.