Angel's Blog - Comments

MySQL: CAST example

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

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

Comments

Comments are not available for this entry.