banner
RustyNail

RustyNail

coder. 【blog】https://rustynail.me 【nostr】wss://ts.relays.world/ wss://relays.world/nostr

sql 分隔逗号

 select distinct substring_index(substring_index(a.m, ','
                                             , b.help_topic_id + 1), ',', -1) m,
                         a.f
         from mm a
                  join
              mysql.help_topic b
              on b.help_topic_id < (length(a.m) - length(replace(a.m, ',', '')) + 1)
         where type = 2
         
         // m -> 1,2,3
加载中...
此文章数据所有权由区块链加密技术和智能合约保障仅归创作者所有。