📄️ ASCII
Returns the numeric value of the leftmost character of the string str.
📄️ 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. A multibyte character counts as a single character. This means that for a string containing five 2-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.
📄️ 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.
📄️ FROM_BASE64
Takes a string encoded with the base-64 encoded rules nd returns the decoded result as a binary string. The result is NULL if the argument is NULL or not a valid base-64 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. This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed.
📄️ 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. The second syntax returns the position of the first occurrence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str. Returns NULL if any argument is NULL.
📄️ 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. If str is longer than len, the return value is shortened to 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). Returns the position of the first occurrence of substring substr in string str. Returns 0 if substr is not in str. Returns NULL if any argument is NULL.
📄️ 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. If str is longer than len, the return value is shortened to 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. The forms without a len argument return a substring from string str starting at position pos. The forms with a len argument return a substring len characters long from string str, starting at position pos. It is also possible to use a negative value for pos. In this case, the beginning of the substring is pos characters from the end of the string, rather than the beginning. A negative value may be used for pos in any of the forms of this function. A value of 0 for pos returns an empty string. The position of the first character in the string from which the substring is to be extracted is reckoned as 1.
📄️ TO_BASE64
Converts the string argument to base-64 encoded form and returns the result as a character string. If the argument is not a string, it is converted to a string before conversion takes place. The result is NULL if the argument is NULL.
📄️ TRIM
Returns the string without leading or trailing occurrences of the specified remove string. If remove string is omitted, spaces are 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.