查找笔记中的所有代办

经过大佬们的帮助和 chatgpt 的帮助
我终于学会了 sql 查找代办的方法
分享一下
原帖子笔记中查看所有代办标签 - ciwoyipang 的回帖 - 链滴 (ld246.com)

感谢大家帮助
重点感谢一下 @ 赐我一胖 这位哥

查看所有笔记中的所有代办

SELECT DISTINCT * FROM blocks
WHERE subtype = 't'
AND type = 'i'
AND (markdown LIKE '%[X]%' OR markdown LIKE '%[ ]%')

或者

SELECT DISTINCT * FROM blocks
WHERE subtype = 't'
AND type = 'i'
AND markdown LIKE '%[%]%'

查看所有笔记中的所有已完成代办

SELECT DISTINCT * FROM blocks
WHERE subtype = 't'
AND type = 'i'
AND (markdown LIKE '%[X]%')

查看所有笔记中的所有未完成代办

SELECT DISTINCT * FROM blocks
WHERE subtype = 't'
AND type = 'i'
AND (markdown LIKE '%[ ]%')

查看某一笔记中的所有代办

SELECT DISTINCT * FROM blocks
WHERE markdown LIKE '%[X]%'
AND subtype = 't'
AND type = 'i'
AND box = '20230409180737-e63h8sp'

查看多个笔记中的所有代办

SELECT * FROM blocks
WHERE markdown LIKE '%[X]%'
AND subtype = 't'
AND type = 'i'
AND box IN ('box1', 'box2', 'box3');