#### FIND_IN_SET FIND_IN_SET(str,strlist) 如果字符串str是在的strlist組成的N子串的字符串列表之中的時候，返回值的范圍為1到N。 ~~~ SQL> SELECT FIND_IN_SET('b','a,b,c,d'); +---------------------------------------------------------+ | SELECT FIND_IN_SET('b','a,b,c,d') | +---------------------------------------------------------+ | 2 | +---------------------------------------------------------+ 1 row in set (0.00 sec) ~~~ mysql一個字段多個值關聯另一張表，A表的id字段是以'1,2,3,4,5'...這樣的形式存的，它關聯字典表B的id字段，此時需求是要查出name ~~~ SELECT a.id, ( SELECT GROUP_CONCAT(t.NAME) FROM test t WHERE FIND_IN_SET( t.id, a.fixedAssetClass ) )name FROM table a WHERE a.id = '123' ~~~