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

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

On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
> Apparently not!
>
> mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM
> DATA_TABLE_PID_1_DESC_137;

Is it so hard to read directions?

select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;

This assumes whatever is in that column, was encoded.

Jeff

--nextPart2163248.lh9i9xWxP3
Content-Type: application/pgp-signature

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

iD8DBQBCA9eKoOk9EvUvEtgRAtKlAJ9lFtWBjeRoenbfhtA1Pzq6e97v8wCfQraV
vq0VsdWZ2klK+xxR+9uDSuM=
=bjhD
-----END PGP SIGNATURE-----

--nextPart2163248.lh9i9xWxP3--