On 29-Jun-01 Sönke Tesch wrote:
> Hi!
>
> The CASE statement doesn't seem to work, even the three examples given in
> the
> docs (7.4.8 Control Flow Functions) return errors:
>
> mysql> select case 1 when 1 then "one" when 2 then "two" else "more" end;
> ERROR 1064: You have an error in your SQL syntax near '1 when 1 then "one"
> when
> 2 then "two" else "more" end' at line 1
>
> I tried it with my local copy (Ver 9.38 Distrib 3.22.32, for pc-linux-gnu
> (i686),
> Debian distribution), as well as with the one installed at my ISP.
>
> What's happening here?
CASE didn't show up till 3.23.3
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
