IF STATEMENT INSIDE MYSQL

[ade234uk]

This is the code I currently use to convert the unix timestamp from the field paid_on_date

SELECT from_unixtime(aa.paid_on_date, '%b %D %Y' ) AS Paid

I have recently made some changes to some code. What I need to know is how I insert an IF statement in the mysql statement so that

IF aa.paid_on_date = 0 {display some text}
else
convert the unix timestamp as usual

[Lars_Berg]

use a case expression

select case when aa.paid = 0 then 
        'display' some text' 
     else from_unixtime(aa.paid_on_date, '%b %D %Y' ) end AS Paid
...