mysql if

select if(attachment=2,0.3,0) as a,tid from pre_forum_thread select credit/(1416992327-regdate) from pre_common_members where credit > 0