Mark1inLA Posted October 15, 2008 Share Posted October 15, 2008 Hello all, This is in regards to the AES_DECRYPT(column, password) function that returns an unencrypted value from an AES encrypted column. I can return the value that i'm looking for if there are no other tables involved. But when i include this function in a join, the value returns a blank value. Anyone know why that is? Thanks in advanced. Quote Link to comment https://forums.phpfreaks.com/topic/128607-solved-aes_decrypt-in-mysql/ Share on other sites More sharing options...
fenway Posted October 16, 2008 Share Posted October 16, 2008 Never heard of that! Quote Link to comment https://forums.phpfreaks.com/topic/128607-solved-aes_decrypt-in-mysql/#findComment-667122 Share on other sites More sharing options...
Mark1inLA Posted October 16, 2008 Author Share Posted October 16, 2008 I should've tested this on some sample tables before posting. It turns out the records that had values were not part of the join (which explains why the values weren't showing up in the join but did show up when i removed it). Quote Link to comment https://forums.phpfreaks.com/topic/128607-solved-aes_decrypt-in-mysql/#findComment-667257 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.