find_in_set(str,strlist)

type字段(“推荐”,”置顶”)

SELECT * FROM USER WHERE FIND_IN_SET(‘推荐’,type);