在字符串中查找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

原文地址:https://www.cnblogs.com/lxwphp/p/8676037.html