编写MySQL搜索列中的多个值

SELECT 
    ID, 
    Division, 
    EffectiveDate, 
    PM, 
    case Status 
        when 0 then 'Dead'
        when 1 then 'Active'
        when 2 then 'Job'
        when 3 then 'Pending'
        when 4 then 'Sales Lead'
        when 5 then 'Budget'
        when 6 then 'Change Order'
    end as Status, 
    Name, 
    Address, 
    ProjectType
FROM intranet.t_bidinfo
WHERE Division = 'TI'
AND EffectiveDate >= '2015-06-01'
AND Status = 6
ORDER BY EffectiveDate ASC
;
SELECT 
    ID, 
    Division, 
    EffectiveDa