mysql解法:
select
a.id,
a.str,
substring_index( substring_index( a.keys, ';', b.help_topic_id + 1 ), ';',- 1 ) as `key`
from
(select id, str, case when str like "%e%o%" then 'e;o' when str like "%o%" then 'o' when str like "%e%" then 'e' end `keys` from tb_str) as a
join mysql.help_topic as b on b.help_topic_id < ( length( a.keys ) - length( replace ( a.keys, ';', '' ) ) + 1 );