String Functions

📄️ CHAR

Return the character for each integer passed.

📄️ CHAR_LENGTH

Returns the length of the string str, measured in characters.

📄️ CHARACTER_LENGTH

CHARACTERLENGTH() is a synonym for CHARLENGTH().

Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent nonbinary string form.

📄️ CONCAT_WS

CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be a string, as can the rest of the arguments. If the separator is NULL, the result is NULL.

📄️ ELT

Returns the Nth element of the list of strings: str1 if N = 1, str2 if N = 2, and so on.

📄️ EXPORT_SET

Returns a string such that for every bit set in the value bits,

📄️ FIELD

Returns the index (position) of str in the str1, str2, str3, ... list. Returns 0 if str is not found.

📄️ FIND_IN_SET

Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings.

📄️ FROM_BASE64

Takes a string encoded with the base-64 encoded rules nd returns the decoded result as a binary string.

📄️ INSERT

Returns the string str, with the substring beginning at position pos and len characters long replaced by the string newstr. Returns the original string if pos is not within the length of the string. Replaces the rest of the string from position pos if len is not within the length of the rest of the string. Returns NULL if any argument is NULL.

📄️ INSTR

Returns the position of the first occurrence of substring substr in string str.

📄️ LCASE

Synonym for LOWER(str).

📄️ LEFT

Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

📄️ LENGTH

Return the length of a string in bytes.

📄️ LOCATE

The first syntax returns the position of the first occurrence of substring substr in string str.

📄️ LOWER

Returns the string str with all characters changed to lowercase.

📄️ LPAD

Returns the string str, left-padded with the string padstr to a length of len characters.

📄️ MID

Synonym for SUBSTRING(str,pos,len).

📄️ ORD

If the leftmost character is not a multibyte character, ORD() returns the same value as the ASCII() function.

📄️ POSITION

POSITION(substr IN str) is a synonym for LOCATE(substr,str).

📄️ REGEXP_INSTR

Returns the starting index of the substring of the string expr that matches the regular expression specified by the pattern pat, 0 if there is no match. If expr or pat is NULL, the return value is NULL. Character indexes begin at 1.

📄️ REGEXP_LIKE

REGEXP_LIKE function is used to check that whether the string matches regular expression.

📄️ REGEXP_REPLACE

Replaces occurrences in the string expr that match the regular expression specified by the pattern pat with the replacement string repl, and returns the resulting string. If expr, pat, or repl is NULL, the return value is NULL.

📄️ REGEXP_SUBSTR

Returns the substring of the string expr that matches the regular expression specified by the pattern pat, NULL if there is no match. If expr or pat is NULL, the return value is NULL.

📄️ REPLACE

Returns the string str with all occurrences of the string fromstr replaced by the string tostr.

📄️ REVERSE

Returns the string str with the order of the characters reversed.

📄️ RIGHT

Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

📄️ RPAD

Returns the string str, right-padded with the string padstr to a length of len characters.

📄️ SOUNDEX

Returns a soundex string from str. Two strings that sound almost the same should have identical soundex strings. A standard soundex string is four characters long, but the SOUNDEX() function returns an arbitrarily long string. You can use SUBSTRING() on the result to get a standard soundex string. All nonalphabetic characters in str are ignored. All international alphabetic characters outside the A-Z range are treated as vowels.