mysql 字符分割成列
2023-02-13 本文已影响0人
王宣成
字段:applicant
值:张三;李四;王五
SELECT substring_index( substring_index( a.applicant, ';', b.help_topic_id + 1 ), ';',- 1 ) as applicant from tcaplus_autoinstall.app_info_bas as `a` JOIN mysql.help_topic b ON b.help_topic_id < ( length( a.applicant ) - length( REPLACE ( a.applicant, ';', '' ) ) + 1 ) where `app_id` = 47