If all my columns are encrypted, is it true that I can not use a simple
'select * from' anymore. Instead I need to do:
select AES_DECRYPT( column1 , 'mykey' ), AES_DECRYPT( column2 ,
'mykey' ),
AES_DECRYPT( column3_etc... , 'mykey' )
This would make my code rather long . Is there a shortcut I am missing?
On 18 Jul 2006 21:42:49 -0700, in mailing.database.mysql
veg_all@yahoo.com
<1153284169.898914.168450@i42g2000cwa.googlegroups.com> wrote:
>| If all my columns are encrypted, is it true that I can not use a simple
>| 'select * from' anymore. Instead I need to do:
>|
>| select AES_DECRYPT( column1 , 'mykey' ), AES_DECRYPT( column2 ,
>| 'mykey' ),
>| AES_DECRYPT( column3_etc... , 'mykey' )
>|
>| This would make my code rather long . Is there a shortcut I am missing?
Perhaps:
SET @key='thisisthesecretkey';
select AES_DECRYPT(column1, @key), AES_DECRYPT(column2,@key),
AES_DECRYPT(column3_etc...,@key)
------------------------------------------------------------ ---
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
------------------------------------------------------------ ---