📄️ ASCII
Returns the numeric value of the leftmost character of the string str.
String Functions
📄️ BIN
Returns a string representation of the binary value of N.
📄️ BIT_LENGTH
Return the length of a string in bits.
📄️ 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().
📄️ CONCAT
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.
📄️ FORMAT
Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string.
📄️ FROM_BASE64
Takes a string encoded with the base-64 encoded rules nd returns the decoded result as a binary string.
📄️ HEX
For a string argument str, HEX() returns a hexadecimal string representation of str where each byte of each character in str is converted to two hexadecimal digits. The inverse of this operation is performed by the UNHEX() function.
📄️ 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.
📄️ LIKE
Pattern matching using an SQL pattern. Returns 1 (TRUE) or 0 (FALSE). If either expr or pat is NULL, the result is NULL.
📄️ 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).
📄️ NOT LIKE
Pattern not matching using an SQL pattern. Returns 1 (TRUE) or 0 (FALSE). If either expr or pat is NULL, the result is NULL.
📄️ NOT REGEXP
Returns 1 if the string expr doesn't match the regular expression specified by the pattern pat, 0 otherwise.
📄️ NOT RLIKE
Returns 1 if the string expr doesn't match the regular expression specified by the pattern pat, 0 otherwise.
📄️ OCT
Returns a string representation of the octal value of N.
📄️ OCTET_LENGTH
OCTET_LENGTH() is a synonym for LENGTH().
📄️ 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).
📄️ QUOTE
Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement.
📄️ REGEXP
Returns 1 if the string expr matches the regular expression specified by the pattern pat, 0 otherwise.
📄️ 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.
📄️ REPEAT
Returns a string consisting of the string str repeated count times. If count is less than 1, returns an empty string. Returns NULL if str or count are 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.
📄️ RLIKE
Returns 1 if the string expr matches the regular expression specified by the pattern pat, 0 otherwise.
📄️ 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.
📄️ SPACE
Returns a string consisting of N space characters.
📄️ STRCMP
Returns 0 if the strings are the same, -1 if the first argument is smaller than the second, and 1 otherwise.
📄️ SUBSTR
Synonym for SUBSTRING(str,pos,len).
📄️ SUBSTRING
SUBSTRING function is used to extract a string containing a specific number of characters from a particular position of a given string.
📄️ SUBSTRING_INDEX
Returns the substring from string str before count occurrences of the delimiter delim.
📄️ TO_BASE64
Converts the string argument to base-64 encoded form and returns the result as a character string.
📄️ TRIM FUNCTIONS
Returns the string str with all remstr prefixes or suffixes removed.
📄️ UCASE
Synonym for UPPER(str).
📄️ UNHEX
For a string argument str, UNHEX(str) interprets each pair of characters in the argument as a hexadecimal number and converts it to the byte represented by the number. The return value is a binary string.
📄️ UPPER
Returns the string str with all characters changed to uppercase.