FROM_BASE64

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

Was this article helpful?