Hello.
I think you should remove the space after DECODE. "shaun thornburgh" <[EMAIL PROTECTED]> wrote: > Apparently not! > > mysql> SELECT DECODE ( CSV_DATA_ENC_FORENAME, "test_password" ) FROM > DATA_TABLE_PID_1_DESC_137; > ERROR 1064: You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use near '( > CSV_DATA_ENC_FORENAME, "test_password" ) FROM DATA_TABLE_PID_ > mysql> > > Any ideas? > >>From: Jeff Smelser <[EMAIL PROTECTED]> >>To: mysql@lists.mysql.com >>Subject: Re: ENCODE & DECODE >>Date: Fri, 4 Feb 2005 10:20:14 -0600 >> >>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 >><< attach3 >> > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
