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
This function returns the ascii value of the leftmost character of a given string.
char
CHAR() returns the character value of the given integer value according to the ASCII table.
char_length
This function returns the length of a string.
character_length
This function is an alias of `char_length`, please check [char_length](./char_length.md) function for detailed explanation.
concat
This function combines multiple strings.
concat_ws
This function uses the first argument sep as the separator which combines the second with the rest to form a string.
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
This function returns the position of the first str in strlist (start counting with 1).
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
If `x` is a numerical value, this function returns a hexadecimal string representation of the value.
hex_decode_binary
Decodes a hex encoded string to a binary.
hex_decode_string
This function performs the opposite operation of [hex()](hex.md).
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
This function returns the position where str first appeared in substr (start counting from 1 and measured in characters).
lcase
This function converts a string to lower-case.
left
This function returns a specified number of characters from the left side of a given string.
length
This function returns the length of a string (in bytes).
locate
This function is used for finding the location of a substring in a string (starting counting from 1 and measured in characters).
lower
Converts all strings in an argument to lower-case.
lpad
This function returns strings with a length of `len` (starting counting from the first syllable) in `str`.
ltrim
Removes the leading spaces or specified characters from the beginning (left) of the `str` argument.
money_format
This function returns a string formatted as a currency string.
ngram_search
Calculate the ngram similarity of the two strings.
null_or_empty
This function returns true when the string is empty or NULL.
parse_url
Parses a URL and extracts a component from this URL.
regexp_split
Split string `str` by regexp expression `pattern`, return maximum `max_split` elements in `ARRAY<VARCHAR>` type.
repeat
This function repeats `str` by a number of times according to `count`.
replace
Replaces all occurrences of characters in a string with another string.
reverse
Reverses a string or array.
right
This function returns a specified length of characters from the right side of a given string.
rpad
This function returns strings with a length of `len` (starting counting from the first syllable) in `str`.
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
This function splits a given string according to the separators, and returns the split parts in ARRAY.
split_part
This function splits a given string according to the separators and returns the requested part.
starts_with
This function returns 1 when a string starts with a specified prefix.
str_to_map
Splits a given string into key-value pairs using two delimiters and returns a map of the split pairs.
strcmp
This function compares two strings.
strleft
This function extracts a number of characters from a string with specified length (starting from left).
strpos
Returns the position of the N-th substring in a string.
strright
This function extracts a number of characters from a string with specified length (starting from 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
This function converts a string to upper-case.
unhex
This function performs the opposite operation of hex().
upper
Converts a string to upper-case.
url_decode
Translates a string back from the [application/x-www-form-urlencoded](https://www.w3.org/TR/html4/interact/forms.html#h-17.13.4.1) format.
url_encode
Translates a string into the [application/x-www-form-urlencoded](https://www.w3.org/TR/html4/interact/forms.html#h-17.13.4.1) 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.