在字符串中查找id值MySQL

PHPmyadmin中sql语句

 

SELECT *
FROM `hz_article_type`
WHERE FIND_IN_SET( 5, items_id )
LIMIT 0 , 30

 

结果：

SELECT `article_id` FROM `hz_article_type` WHERE ( find_in_set(10,items_id) ) AND `type_id` = 2