Thanx Lewis..It worked
----- Original Message -----
From: "Neville Lewis" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, May 31, 2002 12:34 PM
Subject: RE: Alternative to decode() in Oracle
> Have a look below:
> ------------------
>
> If expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns expr2,
> else it returns expr3. IF() returns a numeric or string value, depending
on
> the context in which it is used:
>
> mysql> select IF(1>2,2,3);
> -> 3
> mysql> select IF(1<2,'yes','no');
> -> 'yes'
> mysql> select IF(strcmp('test','test1'),'no','yes');
> -> 'no'
>
> -------
> expr1 is evaluated as an integer value, which means that if you are
testing
> floating-point or string values, you should do so using a comparison
> operation:
>
> mysql> select IF(0.1,1,0);
> -> 0
> mysql> select IF(0.1<>0,1,0);
> -> 1
> -------
> mysql> SELECT CASE 1 WHEN 1 THEN "one" WHEN 2 THEN "two" ELSE "more" END;
> -> "one"
> mysql> SELECT CASE WHEN 1>0 THEN "true" ELSE "false" END;
> -> "true"
> mysql> SELECT CASE BINARY "B" when "a" then 1 when "b" then 2 END;
> -> NULL
>
>
> -------
>
>
> mysql> select 'Monty!' REGEXP 'm%y%%';
> -> 0
> mysql> select 'Monty!' REGEXP '.*';
> -> 1
> mysql> select 'new*\n*line' REGEXP 'new\\*.\\*line';
> -> 1
> mysql> select "a" REGEXP "A", "a" REGEXP BINARY "A";
> -> 1 0
> mysql> select "a" REGEXP "^[a-d]";
> -> 1
>
>
>
> -----------------
> Did that help?
>
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
