List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 4 2000 8:37pm
Subject:Re: problem with CASE function
View as plain text  
In the last episode (Feb 04), jk said:
> Hi.  The MySQL Reference Manual includes several examples of using the
> CASE function:

> When I try to run them, I get:
> mysql> SELECT CASE WHEN 1>0 THEN "true" ELSE "false" END;
> ERROR 2000: You have an error in your SQL syntax near '1>0 THEN "true"
> ELSE "false" END' at line 1
> I'm using version 3.22.27... didn't see anything in the changes file
> on this.

From the manual:

   Changes in release 3.23.3

   * Added `CASE' construct.

You need to run 3.23.3 or newer.  The Reference Manual for your
specific MySQL version should be installed on your local filesystem, in
/usr/local/share/doc/mysql/manual.{txt,html} , or a similar directory.

	Dan Nelson
problem with CASE functionjk4 Feb
  • Re: problem with CASE functionDan Nelson4 Feb