[Solved] MySql case statement error

by

[ad_1]

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

[ad_2]

solved MySql case statement error