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