from_base64

description

Syntax

VARCHAR from_base64(VARCHAR str)

返回对输入的字符串进行Base64解码后的结果，当输入字符串不正确时（出现非Base64编码后可能出现的字符）将会返回NULL

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