FROM_BASE64

Syntax

FROM_BASE64(str)

Purpose

FROM_BASE64() decodes a Base64-encoded string and returns it as a binary string. It is usually used to decode a string encoded by the TO_BASE64() function. For more information, see TO_BASE64().

Examples

obclient> SELECT FROM_BASE64('T0I=');
+---------------------+
| FROM_BASE64('T0I=') |
+---------------------+
| OB                  |
+---------------------+
1 row in set