[760]sqllite中实现字符串分割

周小董

发布于 2020-02-17 08:03:39

2K0

发布于 2020-02-17 08:03:39

sqlite 从固定字符串分隔

WITH split(word, str) AS (
    -- alternatively put your query here
    -- SELECT '', category||',' FROM categories
    SELECT '', 'Auto,A,1234444,dsfdd,sd,sd,77'||','
    UNION ALL SELECT
    substr(str, 0, instr(str, ',')),
    substr(str, instr(str, ',')+1)
    FROM split WHERE str!=''
) SELECT word FROM split WHERE word!='';

sqlite 从表中获取数据

WITH split(word, str) AS (
    SELECT '', (select chi_sht from tr_map_org_basic where com_name_en='code cat' and status=1)||','
    UNION ALL SELECT
    substr(str, 0, instr(str, ',')),
    substr(str, instr(str, ',')+1)
    FROM split WHERE str!=''
) SELECT word FROM split WHERE word!='';

sqlite 从表中获取数据，union all 连接语句

WITH split(word, str) AS (
    SELECT '', (select chi_sht from tr_map_org_basic where com_name_en='code cat' and status=1)||','
    UNION ALL SELECT
    substr(str, 0, instr(str, ',')),
    substr(str, instr(str, ',')+1)
    FROM split WHERE str!=''
) SELECT word FROM split WHERE word!=''
union all select eng_sht from tr_map_org_basic where com_name_en='code cat';

参考：https://blog.csdn.net/weixin_30381793/article/details/98222363

https://blog.csdn.net/yannie3321/article/details/82153747 https://blog.csdn.net/zeeeitch/article/details/7038871 https://www.cnblogs.com/David3290/p/11378579.html

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

原始发表：2020-02-08 ，如有侵权请联系 cloudcommunity@tencent.com 删除

https