# FROM\_BASE64

Takes a base-64 encoded string and returns the decoded result as a binary string.

The result is NULL if the argument is NULL or an invalid base-64 string.

## Syntax

```sql
FROM_BASE64 (str)

```

## Arguments

* `str`: a base-64 encoded string

## Return Type

Binary string (blob)

## Examples

```sql
SELECT TO_BASE64('abracadabra'), FROM_BASE64(TO_BASE64('abracadabra'));

```

```output

+--------------------------+---------------------------------------+
| TO_BASE64('abracadabra') | FROM_BASE64(to_base64('abracadabra')) |
+--------------------------+---------------------------------------+
| YWJyYWNhZGFicmE=         | abracadabra                           |
+--------------------------+---------------------------------------+

```

***

Modified at: February 27, 2023

Source: [/db/v9.1/reference/sql-reference/string-functions/from-base-64/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/from-base-64/)

(An index of the documentation is available at /llms.txt)