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

1. mysql> select from_base64('MQ==');
2. +---------------------+
3. | from_base64('MQ==') |
4. +---------------------+
5. | 1                   |
6. +---------------------+

8. mysql> select from_base64('MjM0');
9. +---------------------+
10. | from_base64('MjM0') |
11. +---------------------+
12. | 234                 |
13. +---------------------+

keywords

1. from_base64