String Functions

Return the length of a string in bits.

Return the character for each integer passed.

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

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() 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.

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

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

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

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

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

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.

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

Synonym for LOWER(str).

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

Return the length of a string in bytes.

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

Returns the string str with all characters changed to lowercase.

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

Synonym for SUBSTRING(str,pos,len).

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

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

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

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

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

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

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

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.

Returns a string consisting of N space characters.

Returns 0 if the strings are the same, -1 if the first argument is smaller than the second, and 1 otherwise.

Synonym for SUBSTRING(str,pos,len).

SUBSTRING function is used to extract a string containing a specific number of characters from a particular position of a given string.

Returns the substring from string str before count occurrences of the delimiter delim.

Converts the string argument to base-64 encoded form and returns the result as a character string.

Synonym for UPPER(str).

Returns the string str with all characters changed to uppercase.