[Solved] MySql case statement error


Do it like this example:

try to run this

 set @fulfillStatus = 1;
    select 
    CASE 
        when @fulfillStatus = 0 then 'open'
        when @fulfillStatus = 1 then 'processing'
        when @fulfillStatus = 2 then 'complete'
        when @fulfillStatus = 5 then 'Shipped'
        when @fulfillStatus = 9 then 'void'
    else "None"
    END as "Order Status"

3

solved MySql case statement error