String functions
append_trailing_char_if_absent
If the str string is not empty and does not contain trailing_char character in the end, it appends trailing_char character to the end.
ascii
Returns the ASCII code of the leftmost character of a string.
char
CHAR() returns the character value of the given integer value according to the ASCII table.
char_length
Returns the number of characters in a string.
character_length
Alias of char_length; returns the number of characters in a string.
concat
Concatenates multiple strings into a single string.
concat_ws
Concatenates strings using a specified separator between each argument.
crc32
Returns the 32-bit cyclic redundancy check (CRC) value of a string.
ends_with
Returns true if a string ends with a specified suffix.
field
Returns the index (position) of a value in a list of values.
find_in_set
Returns the 1-based position of a string within a comma-separated list.
format_bytes
Converts a byte count into a human-readable string with appropriate units (B, KB, MB, GB, TB, PB, EB).
group_concat
Concatenates non-null values from a group into a single string, with a sep argument, which is , by default if not specified.
hex
Converts a numeric or string value to its hexadecimal representation.
hex_decode_binary
Decodes a hex encoded string to a binary.
hex_decode_string
Converts a hexadecimal-encoded string back to its original string value; inverse of hex.
inet_aton
Takes a string containing an IPv4 address in the format A.B.C.D.
initcap
Converts the first letter of each word in a string to uppercase and the remaining characters to lowercase.
instr
Returns the 1-based character position of the first occurrence of a substring within a string.
lcase
Converts a string to lowercase; alias of lower.
left
Returns a specified number of characters from the left side of a string.
length
Returns the byte length of a string.
locate
Returns the 1-based character position of a substring within a string.
lower
Converts all strings in an argument to lower-case.
lpad
Left-pads a string with a pad string to reach the specified length.
ltrim
Removes the leading spaces or specified characters from the beginning (left) of the str argument.
money_format
Formats a numeric value as a currency string with two decimal places and thousands separators.
ngram_search
Calculate the ngram similarity of the two strings.
null_or_empty
Returns true if the string is NULL or an empty string.
parse_url
Parses a URL string and extracts a specified component such as host, path, or query parameter.
regexp_split
Split string str by regexp expression pattern, return maximum max_split elements in ARRAY<VARCHAR> type.
repeat
Returns a string repeated a specified number of times.
replace
Replaces all occurrences of characters in a string with another string.
reverse
Reverses a string or array.
right
Returns a specified number of characters from the right side of a string.
rpad
Right-pads a string with a pad string to reach the specified length.
rtrim
Removes the trailing spaces or specified characters from the end (right) of the str argument.
space
Returns a string of the specified number of spaces.
split
Splits a string by a delimiter and returns the resulting parts as an ARRAY.
split_part
Splits a string by a delimiter and returns the Nth part.
starts_with
Returns 1 if a string starts with the specified prefix, or 0 otherwise.
str_to_map
Splits a given string into key-value pairs using two delimiters and returns a map of the split pairs.
strcmp
Compares two strings and returns 0 if equal, -1 if the first is smaller, or 1 if larger.
strleft
Returns a specified number of characters from the left of a string; alias of left.
strpos
Returns the position of the N-th substring in a string.
strright
Returns a specified number of characters from the right of a string; alias of right.
substring, substr
Extracts characters staring from the specified position and returns a substring of specified length.
substring_index
Extracts a substring that precedes or follows the count occurrences of the delimiter.
tokenize
Splits and parses text into tokens based on the specified tokenizer.
translate
Substitutes specified characters within a string.
trim
Removes consecutive spaces or specified characters from the beginning and end of the str argument.
ucase
Converts a string to uppercase; alias of upper.
unhex
Converts a hexadecimal string to its original binary string; inverse of hex.
upper
Converts a string to upper-case.
url_decode
Translates a string back from the application/x-www-form-urlencoded format.
url_encode
Translates a string into the application/x-www-form-urlencoded format.
url_extract_host
Extracts the host section from a URL.
url_extract_parameter
Extracts the value of the requested name parameter from the query string of a URL.