select * from t_prod_society_lsh order by case when societyTitle='主席' then 1 when societyTitle='副主席' then 2 when societyTitle='会长' then 3 when societyTitle='副会长' then 4 when societyTitle='理事长' then 5
when societyTitle='副理事长' then 6 when societyTitle='秘书长' then 7
when societyTitle='无' then 8 when societyTitle is null then 9
end asc