ποΈ 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.
