📄️ 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.
📄️ 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.
📄️ 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(, , ).
📄️ 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
Generates the Soundex code for a string.
📄️ SOUNDS LIKE
Compares the pronunciation of two strings by their Soundex codes. Soundex is a phonetic algorithm that produces a code representing the pronunciation of a string, allowing for approximate matching of strings based on their pronunciation rather than their spelling. Databend offers the SOUNDEX function that allows you to get the Soundex code from a string.
📄️ SPACE
Returns a string consisting of N blank 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(, , ).
📄️ SUBSTRING
SUBSTRING function is used to extract a string containing a specific number of characters from a particular position of a given string.
📄️ TO_BASE64
Converts the string argument to base-64 encoded form and returns the result as a character string.
📄️ TRIM
Returns the string without leading or trailing occurrences of the specified remove string. If remove string
📄️ UCASE
Synonym for UPPER().
📄️ 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.