On 04/26/11 05:32, Halász Sándor wrote:
2011/04/25 18:45 +0000, Larry McGhaw>>>>
CREATE VIEW `myview2` AS
       SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName`
         FROM `mytable` a
           LEFT JOIN `types` b ON a.`Type` = b.`ID`;
<<<<<<<<
Well, for this construct
IF(b.`Name` IS NULL, '', b.`Name`)
there is a special function IFNULL:
IFNULL(b.`Name`, '')
It has the same special type-treatment that IF has.

Wow, thanks! I wasn't aware of it, but this looks helpful in my case (at least simplifying those expressions)!

Yours,
Daniel

--
http://www.pro-vegan.info/
--
Done:  Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to