Skip to main content
Skip to main content

FROM_BASE64

from_base64

description

Syntax

VARCHAR from_base64(VARCHAR str)

Returns the result of Base64 decoding the input string, NULL is returned when the input string is incorrect (with non-Base64 encoded characters).

example

mysql> select from_base64('MQ==');
+---------------------+
| from_base64('MQ==') |
+---------------------+
| 1 |
+---------------------+

mysql> select from_base64('MjM0');
+---------------------+
| from_base64('MjM0') |
+---------------------+
| 234 |
+---------------------+

keywords

from_base64