处理字段里存在多个值分割处理，提取需要的数据

 

select 
*
from
alg_server
where ID
in
(
SELECt
DISTINCT
a.ID
from
alg_server a
JOIN mysql.help_topic b
ON b.help_topic_id < ( LENGTH (a.APPLICATION) - LENGTH(REPLACE(a.APPLICATION,',',''))+1)
WHERE SUBSTRING_INDEX (SUBSTRING_INDEX (replace(a.APPLICATION, '%', ''),',',b.help_topic_id + 1),',',- 1) < 80)