HeatWave Release Notes
The following table shows supported string functions and
operators. With the exception of the
FORMAT()
function, string functions and
operators described in the following table are supported with
variable-length encoded columns. Dictionary encoded columns
are not supported.
Table 2.11 String Functions and Operators
Name | Description |
---|---|
ASCII() |
Return numeric value of left-most character |
BIT_LENGTH() |
Return length of argument in bits |
CHAR_LENGTH() |
Return number of characters in argument |
CONCAT() |
Return concatenated string |
CONCAT_WS() |
Return concatenated with separator |
FIND_IN_SET() |
Index (position) of first argument within second argument |
FORMAT() |
Return a number formatted to specified number of decimal places. Does not support variable-length-encoded columns. |
FROM_BASE64() |
Decode base64 encoded string and return result |
GREATEST() |
Return the largest argument. Temporal types are supported as of MySQL
8.0.30 with the exception of the
YEAR type. |
HEX() |
Hexadecimal representation of decimal or string value |
INSERT() |
Return the index of the first occurrence of substring |
INSTR() |
Return the index of the first occurrence of substring |
LEAST() |
Return the smallest argument. Temporal types are supported as of MySQL
8.0.30 with the exception of the
YEAR type. |
LEFT() |
Return the leftmost number of characters as specified |
LENGTH() |
Return the length of a string in bytes |
LIKE |
Simple pattern matching |
LOCATE() |
Return the position of the first occurrence of substring |
LOWER() |
Return the argument in lowercase |
LPAD() |
Return the string argument, left-padded with the specified string |
LTRIM() |
Remove leading spaces |
NOT LIKE |
Negation of simple pattern matching |
OCTET_LENGTH() |
Synonym for LENGTH()
|
ORD() |
Return character code for leftmost character of the argument |
POSITION() |
Synonym for LOCATE()
|
REPEAT() |
Repeat a string the specified number of times |
QUOTE() |
Escape the argument for use in an SQL statement |
REGEXP |
Whether string matches regular expression |
REGEXP_LIKE() |
Whether string matches regular expression |
REGEXP_REPLACE() |
Replace substrings matching regular expression. Supports up to three arguments. |
REGEXP_SUBSTR() |
Return substring matching regular expression. Supports up to three arguments. |
REPLACE() |
Replace occurrences of a specified string |
REVERSE() |
Reverse the characters in a string |
RIGHT() |
Return the specified rightmost number of characters |
RLIKE |
Whether string matches regular expression |
RPAD() |
Append string the specified number of times |
RTRIM() |
Remove trailing spaces |
STRCMP() |
Compare two strings |
SUBSTR() |
Return the substring as specified |
SUBSTRING() |
Return the substring as specified |
SUBSTRING_INDEX() |
Return a substring from a string before the specified number of occurrences of the delimiter |
TO_BASE64() |
Return the argument converted to a base-64 string |
TRIM() |
Remove leading and trailing spaces |
UNHEX() |
Return a string containing hex representation of a number |
UPPER() |
Convert to uppercase |