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/[email protected]
