Re: Using AES_DECRYPT displays NULL

[Rick James]

You were missing an UNHEX():

mysql> SELECT CAST(AES_DECRYPT(UNHEX('e570ca3c339299069727ba6d33fec255'), 'y') AS CHAR);
+---------------------------------------------------------------------------+
| CAST(AES_DECRYPT(UNHEX('e570ca3c339299069727ba6d33fec255'), 'y') AS CHAR) |
+---------------------------------------------------------------------------+
| x                                                                         |
+---------------------------------------------------------------------------+
1 row in set (0.00 sec)

And I don't know why you added the CAST():

mysql> SELECT AES_DECRYPT(UNHEX('e570ca3c339299069727ba6d33fec255'), 'y');
+-------------------------------------------------------------+
| AES_DECRYPT(UNHEX('e570ca3c339299069727ba6d33fec255'), 'y') |
+-------------------------------------------------------------+
| x                                                           |
+-------------------------------------------------------------+
1 row in set (0.00 sec)