String & binary functions¶
This family of functions perform operations on a string input value, or binary input value (for certain functions), and return a string or numeric value.
The functions are grouped by type of operation performed.
Function Name |
Binary Input Supported |
Collation Supported |
Notes |
---|---|---|---|
General Manipulation |
|||
✔ |
|||
✔ |
✔ |
||
✔ |
✔ |
||
✔ |
|||
✔ |
|||
✔ |
|||
✔ |
|||
✔ |
|||
✔ |
|||
✔ |
Provides partial support for collation. For details, see the documentation of the function. |
||
Full-Text Search |
|||
Case Conversion |
|||
Regular Expression Matching |
|||
Alias for RLIKE. |
|||
Alias for REGEXP_SUBSTR_ALL. |
|||
Alias for RLIKE. |
|||
Other Matching/Comparison |
|||
✔ |
✔ |
Alias for POSITION. Provides partial support for collation. For details, see the documentation of the POSITION function. |
|
✔ |
✔ |
Provides partial support for collation. For details, see the documentation of the function. |
|
✔ |
✔ |
Provides partial support for collation. For details, see the documentation of the function. |
|
Case-insensitive alternative for LIKE. |
|||
Case-insensitive alternative for LIKE ANY. |
|||
✔ |
✔ |
||
✔ |
✔ |
Provides partial support for collation. For details, see the documentation of the function. |
|
✔ |
✔ |
||
✔ |
✔ |
Provides partial support for collation. For details, see the documentation of the function. |
|
✔ |
✔ |
||
Compression/Decompression |
|||
✔ |
|||
✔ |
|||
✔ |
|||
Encoding/Decoding |
|||
✔ |
|||
✔ |
|||
Error-handling version of BASE64_DECODE_BINARY. |
|||
Error-handling version of BASE64_DECODE_STRING. |
|||
Error-handling version of HEX_DECODE_BINARY. |
|||
Error-handling version of HEX_DECODE_STRING. |
|||
Cryptographic/Checksum |
|||
Intended primarily for checksum operations. Not recommended for cryptography. |
|||
Intended primarily for checksum operations. Not recommended for cryptography. |
|||
Intended primarily for checksum operations. Not recommended for cryptography. |
|||
Intended primarily for checksum operations. Not recommended for cryptography. |
|||
Hash (Non-cryptographic) |
|||
✔ |
Allows data types other than string and binary. Not intended for cryptography. |
||
✔ |
Allows data types other than string and binary. Not intended for cryptography. |
||
Collation |
|||
Large Language Model |
|||