FROM_
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Takes a base-64 encoded string and returns the decoded result as a binary string.
The result is NULL if the argument is NULL or an invalid base-64 string.
Syntax
FROM_BASE64 (str)
Arguments
-
str: a base-64 encoded string
Return Type
Binary string (blob)
Examples
SELECT TO_BASE64('abracadabra'), FROM_BASE64(TO_BASE64('abracadabra'));
+--------------------------+---------------------------------------+
| TO_BASE64('abracadabra') | FROM_BASE64(to_base64('abracadabra')) |
+--------------------------+---------------------------------------+
| YWJyYWNhZGFicmE= | abracadabra |
+--------------------------+---------------------------------------+Last modified: February 27, 2023