Hi,
I have a table where users upload various data items via a web site. Some fields in the table are named DATA_ENC... to denote that the data should be encrypted uusing the encode function. This all works fine, however when I come to selecting the data from the table I would like to be able to select all the data and decrypt any fields as required. Is this possible with one query, or do I have to select every data item then decrypt it then present the data?
Thanks for your help
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]