Re: Oracle NVL equivalent for MySQL?
| From: | Maxim Derkachev | Date: | Wed, 04 Apr 2001 12:20:01 +0000 |
| Subject: | Re: Oracle NVL equivalent for MySQL? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-47022@lists.php.net to get a copy of this message | ||
Hello Dominick,
Wednesday, April 04, 2001, 12:32:26 PM, you wrote:
DV> Maybe a bit offtopic, but is there an equivalent for the NVL function in
DV> Oracle for MySQL?
DV> NVL is a function that returns a given result when a value is null
From MySQL manual:
IFNULL(expr1,expr2)
If expr1 is not NULL, IFNULL() returns expr1,
else it returns expr2.
IFNULL() returns a numeric or string value,
depending on the context in which it is used.
--
Best regards,
Maxim Derkachev mailto:kot@books.ru
Symbol-Plus Publishing Ltd.
phone: +7 (812) 324-53-53
http://www.Books.Ru -- All Books of Russia