SELECT FS_ITEM_DESC FROM dictionary
WHERE FS_TYPE = 'prizeType' AND FIND_IN_SET(FS_ITEM_CODE,(SELECT AWARDS FROM tb_textbook WHERE TEXTBOOK_ID = '1'))
FIND_IN_SET ,在一串有律字符串中查找关键字,返回匹配成功的行
例 : FIND_IN_SET('1','1,2,3') 返回true
SELECT FS_ITEM_DESC FROM dictionary
WHERE FS_TYPE = 'prizeType' AND FIND_IN_SET(FS_ITEM_CODE,(SELECT AWARDS FROM tb_textbook WHERE TEXTBOOK_ID = '1'))