obsidian/技术支持/为知笔记/查询笔记文章.md

---

notion-id: 234ca4d7-cb7b-800d-abca-c598f465b5

查询所有空的字符

  SELECT *
FROM wiz_document
WHERE DT_CREATED BETWEEN '2025-07-01' AND '2025-10-01'
  AND (
    BODY_TEXT IS NULL 
    OR BODY_TEXT REGEXP '^[[:space:]]*$'  -- 匹配纯空白字符串
  );

查询所有有文字的文章案例

• BODY_TEXT IS NOT NULL：排除了 NULL

• BODY_TEXT REGEXP '[[:graph:]]'：只保留 至少包含一个“可见字符” 的正文

  SELECT HEX(DOCUMENT_GUID) AS DOCUMENT_GUID, DOCUMENT_TITLE, BODY_TEXT
  FROM wiz_document 
  WHERE DOCUMENT_TITLE LIKE "%拒绝事%" 
  AND BODY_TEXT IS NOT NULL 
  AND BODY_TEXT REGEXP '[[:graph:]]';
  

查询团队的笔记

SELECT * 
FROM wizksent.wiz_document 
WHERE KB_GUID IN (
    SELECT UNHEX(REPLACE(KB_GUID, '-', ''))
    FROM wizasent.wiz_kb 
    WHERE KB_NAME IS NOT NULL AND KB_NAME != ''
)
AND DT_CREATED >= '2025-07-01' 
AND DT_CREATED < '2025-08-01'
AND DOCUMENT_ABSTRACT_TEXT IS NOT NULL 
AND DOCUMENT_ABSTRACT_TEXT != '';