From: Jeff Smelser
Date: February 4 2005 4:20pm
Subject: Re: ENCODE & DECODE
List-Archive: http://lists.mysql.com/mysql/179451
Message-Id: <200502041020.19218.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart5081588.YehLQWnxj5";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart5081588.YehLQWnxj5
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:

> 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?

Wouldn't select decode(col1) from table work?

Jeff

--nextPart5081588.YehLQWnxj5
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQBCA6DDoOk9EvUvEtgRAoDnAJ0XNvNtg0nwRvCYp2t2F+8vDGePbgCfQo1B
EqSfPmCcUyyBk9LlX2JBmEk=
=zZdI
-----END PGP SIGNATURE-----

--nextPart5081588.YehLQWnxj5--