Lines Matching full:99
43 select ifnull(a+b,99) from t1;
45 } {1 2 4 5 99 99 99}
48 select ifnull(b*c,99) from t1;
50 } {0 0 0 1 99 99 99}
58 select ifnull(case when b<>0 then 1 else 0 end, 99) from t1;
63 select ifnull(case when not b<>0 then 1 else 0 end, 99) from t1;
68 select ifnull(case when b<>0 and c<>0 then 1 else 0 end, 99) from t1;
73 select ifnull(case when not (b<>0 and c<>0) then 1 else 0 end, 99) from t1;
78 select ifnull(case when b<>0 or c<>0 then 1 else 0 end, 99) from t1;
83 select ifnull(case when not (b<>0 or c<>0) then 1 else 0 end, 99) from t1;
88 select ifnull(case b when c then 1 else 0 end, 99) from t1;
93 select ifnull(case c when b then 1 else 0 end, 99) from t1;