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