MySql statement

select if(count(iColorId)!=0,'Red','Yellow') as strColor from tbl_color
count the rows in tbl_color table if count has 0 will print red or yellow.