The examples were created with the MyWAY SQL manager: Download
How to use the MD5() function in MySQL and MariaDB databases
Both MySQL and MariaDB provide a MD5() function used to calculate the MD5 hash of a string. The function takes a string as input and returns a 32-character string with a hexadecimal representation of the MD5 hash. This hash value is often used for simple hashing purposes, such as storing passwords or verifying the integrity of data. MD5 is considered a rather weak hashing algorithm by today's standards, mainly due to its susceptibility to collisions. For more security, stronger hashing algorithms such as SHA-256 or bcrypt should be used.
The MD5() function is not reversible. Once a string hashed with MD5, it is no longer possible to create the original string from the hash value.
Further MySQL und MariaDB SQL Encryption & Compression