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. +---------------------+
  7. mysql> select from_base64('MjM0');
  8. +---------------------+
  9. | from_base64('MjM0') |
  10. +---------------------+
  11. | 234 |
  12. +---------------------+

keywords

  1. from_base64