select * from( select name, a as value from table where sp_a like '%胎%' union all select name, b as value from table where sp_b like '%胎%' union all select name, c as value from table where sp_c like '%胎%' ) data order by value limit 1;
注意到所有字段为 varchar,所以 order by value 改一下 order by cast(value as decimal)
select name, a as value from table where sp_a like '%胎%'
union all
select name, b as value from table where sp_b like '%胎%'
union all
select name, c as value from table where sp_c like '%胎%'
) data order by value limit 1;
order by cast(value as decimal)