Can I use PHP to select base on Case and If? -

in database have entires have key called 'status' , have non-numerical value (such a, b, q)

i want use php script echo different depending on value

right page selects value of key.

edit:

sorry guys. have tried this:

while( $notify = mysql_fetch_array($resultset) ) {      echo '</td><td>'.$notify['status'].'</td></tr>';  }  

as alternative @andre's solution, can transform directly in sql:

select case status when 'a' 'approved'                    when 'b' 'basic'                    when 'q' 'questionable'                    else 'other'        end status_word mytable;