Learn how to understand the AES ENCRYPTION method that is supported by MySQL.
Syntax:
SELECT AES_ENCRYPT('myPassWord','PASSWORD');
Here, the TEXT 'myPassWord' is the text that has to be encrypted and the KEY to encrypt is 'PASSWORD'
Sample output:
+---------------------------------------+
| AES_ENCRYPT('myPassWord','PASSWORD') |
+---------------------------------------+
| (?|??n>?_?? |
+---------------------------------------+
Note: The output is only an illustration and depends on various attributes such as 128-bit, 256-bit, etc.