---
notion-id: 234ca4d7-cb7b-800d-abca-c598f465b54d
---
### 查询所有空的字符
```bash
  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:]]'`：只保留 **至少包含一个“可见字符”** 的正文

```shell
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:]]';
```
### 查询团队的笔记
```javascript
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 != '';
```