方法一：select x.medianame from tb_totle x join tb_new y on **x.medianame like concat('%',y.medianame,'%')**经测试无效，仅保留一行记录
    方法二：select a.aid, a.company,b.bcode from a left join b on **instr(a.company, b.bcode) > 0**