· 9 years ago · Sep 17, 2016, 08:56 PM
1INSERT into encrypted_data (encrypted) VALUES (AES_ENCRYPT('let us hide this stuff', 'secretkey'));
2SELECT AES_DECRYPT(encrypted, 'secretkey') from encrypted_data WHERE AES_DECRYPT(encrypted, 'secretkey') LIKE '%hide%';