Anonyme

SELECT IF(`duree_1` IS NULL,0,`duree_1`) + IF(`duree_2` IS NULL,0,`duree_2`) + IF(`duree_3` IS NULL,0,`duree_3`) + IF(`duree_4` IS NULL,0,`duree_4`) + IF(`duree_5` IS NULL,0,`duree_5`) AS `duree`FROM `affaire`WHERE `id_affaire` =2