The SELECT F_CustomerId, CAST (AES_DECRYPT (unhex (F_MobileEncryption), '* * * * * * * * * *') AS CHAR (50)) AS F_MobileDecrypt
, CAST (AES_DECRYPT (unhex (F_Mobile2Encryption), '* * * * * * * * * *') AS CHAR) AS F_Mobile2Decrypt
, CAST (AES_DECRYPT (unhex (F_Mobile3Encryption), '* * * * * * * * * *') AS CHAR) AS F_Mobile3Decrypt FROM lfine_crm_customer
The same statement, the database can see decryption result, but you can't see the code in decryption result,
Pray god grant instruction