Collections:
FROM_BASE64() - Base64 Decoding
How to decode a Base64 string using the FROM_BASE64() function?
✍: FYIcenter.com
FROM_BASE64(str) is a MySQL built-in function that
decodes a Base64 string.
For example:
SELECT FROM_BASE64('RllJ'), TO_BASE64('FYI');
-- +---------------------+------------------+
-- | FROM_BASE64('RllJ') | TO_BASE64('FYI') |
-- +---------------------+------------------+
-- | FYI | RllJ |
-- +---------------------+------------------+
SELECT FROM_BASE64('My4xNA=='), TO_BASE64(3.14);
-- +-------------------------+-----------------+
-- | FROM_BASE64('My4xNA==') | TO_BASE64(3.14) |
-- +-------------------------+-----------------+
-- | 3.14 | My4xNA== |
-- +-------------------------+-----------------+
Reference information of the FROM_BASE64() function:
FROM_BASE64(str): bin Takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string. Arguments, return value and availability: str: Required. The input Base64 string. bin: Return value. The decoded bytes. Available since MySQL 5.7.
Related MySQL functions:
⇒ HEX() - Calculate HEX representation
⇐ FIND_IN_SET() - Find Substring in List String
2023-11-18, 1627🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Start the Command-Line SQL*Plus in Oracle? If you Oracle server or client installed on your w...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...