I am having a nightmare with mySQL AES_DECRYPT.
I can enrypt things fine, but how do you decrypt a column? For example, I write this line:
insert into tblTest (TestColumn) VALUES (AES_ENCRYPT('testworks','encryptkey'))
which happily inserts "testworks" in encrypted format
When I then try and use:
SELECT TestColumn, AES_DECRYPT(tblTest.TestColumn,'encryptkey') FROM tblTest;
The decrypted column is just nulls. I've been reading google for ages, but I just can't make it work
Any help would be great,