The examples were created with the MyWAY SQL manager: Download
How to use the SHA() function in MySQL and MariaDB databases
Both MySQL and MariaDB provide the SHA() function, which calculates the SHA-1 hash of a given string to obtain a hash value for a specific string of characters, for example for storing hashed passwords, verifying data integrity or for digital signatures.
The SHA-1 is considered a weak hashing algorithm and is no longer recommended for secure hashing purposes. For example, SHA2() function can be used to compute the SHA-256 or SHA-512 hash of a string.
Further MySQL und MariaDB SQL Encryption & Compression