Angel's Blog -

MySQL: CAST example

Monday, September 23, 2013, 07:37 PM - - MySQL Notes
Posted by Administrator

SELECT 
    CAST(CASE eoy
        WHEN 0 THEN 'No Voted' 
         ELSE category/* Keep Original Value*/
    END as CHAR) AS Result
FROM `vote_email`

//see all

SELECT eoy FROM vote_email

[ view entry ] ( 1798 views ) | print article