{
	"ID": "20220415190432-r3xqn3r",
	"Spec": "1",
	"Type": "NodeDocument",
	"Properties": {
		"id": "20220415190432-r3xqn3r",
		"title": "查询语法",
		"updated": "20220502163531"
	},
	"Children": [
		{
			"ID": "20220415192036-99dwwdh",
			"Type": "NodeHeading",
			"HeadingLevel": 2,
			"Properties": {
				"id": "20220415192036-99dwwdh",
				"updated": "20220415201012"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "概述"
				}
			]
		},
		{
			"ID": "20220415190432-6g68nr6",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415190432-6g68nr6",
				"updated": "20220415232302"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "全局搜索 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": "Ctrl+P"
				},
				{
					"Type": "NodeText",
					"Data": " 支持通过查询语法（Query Syntax）进行高级搜索，以便实现一些逻辑操作，比如包含关键字 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "foo"
				},
				{
					"Type": "NodeText",
					"Data": " 并且不包含关键字 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "bar"
				},
				{
					"Type": "NodeText",
					"Data": " 的查询语法为 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "foo NOT bar"
				},
				{
					"Type": "NodeText",
					"Data": "。"
				}
			]
		},
		{
			"ID": "20220415192336-wmv15ws",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415192336-wmv15ws",
				"updated": "20220415193228"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "在使用查询语法之前，我们先大致了解一下该语法的构成："
				}
			]
		},
		{
			"ID": "20220415192647-hkh18bj",
			"Type": "NodeList",
			"ListData": {},
			"Properties": {
				"id": "20220415192647-hkh18bj",
				"updated": "20220415203608"
			},
			"Children": [
				{
					"ID": "20220415192835-v9z0h2o",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415192835-v9z0h2o",
						"updated": "20220415193354"
					},
					"Children": [
						{
							"ID": "20220415192835-3x0xhs3",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415192835-3x0xhs3",
								"updated": "20220415193354"
							},
							"Children": [
								{
									"Type": "NodeText",
									"Data": "字符串（String）：由字母、数字等构成"
								}
							]
						}
					]
				},
				{
					"ID": "20220415192649-4tbip4m",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415192649-4tbip4m",
						"updated": "20220415203608"
					},
					"Children": [
						{
							"ID": "20220415192649-vwqnvuj",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415192649-vwqnvuj",
								"updated": "20220415203608"
							},
							"Children": [
								{
									"Type": "NodeText",
									"Data": "短语（Phrase）：由字符串构成"
								}
							]
						}
					]
				},
				{
					"ID": "20220415192752-qzh0tjm",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415192752-qzh0tjm",
						"updated": "20220415193404"
					},
					"Children": [
						{
							"ID": "20220415192752-tqimcdr",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415192752-tqimcdr",
								"updated": "20220415193404"
							},
							"Children": [
								{
									"Type": "NodeText",
									"Data": "查询（Query）：由短语构成，多个查询可通过 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "AND"
								},
								{
									"Type": "NodeText",
									"Data": "、"
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "OR"
								},
								{
									"Type": "NodeText",
									"Data": " 和 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "NOT"
								},
								{
									"Type": "NodeText",
									"Data": " 组合为新的查询"
								}
							]
						}
					]
				}
			]
		},
		{
			"ID": "20220415192934-mlqzc8m",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415192934-mlqzc8m",
				"updated": "20220415232006"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "下面我们分别介绍它们的细节。"
				}
			]
		},
		{
			"ID": "20220415194256-qagtnkz",
			"Type": "NodeHeading",
			"HeadingLevel": 2,
			"Properties": {
				"id": "20220415194256-qagtnkz",
				"updated": "20220415194259"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "字符串"
				}
			]
		},
		{
			"ID": "20220415194259-bvrexhp",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415194259-bvrexhp",
				"updated": "20220415194339"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "字符串可由两种方式指定："
				}
			]
		},
		{
			"ID": "20220415194339-m0g962e",
			"Type": "NodeList",
			"ListData": {},
			"Properties": {
				"id": "20220415194339-m0g962e",
				"updated": "20220415232543"
			},
			"Children": [
				{
					"ID": "20220415194342-0tzonkx",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415194342-0tzonkx",
						"updated": "20220415202647"
					},
					"Children": [
						{
							"ID": "20220415194342-etshgq1",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415194342-etshgq1",
								"updated": "20220415202647"
							},
							"Children": [
								{
									"Type": "NodeText",
									"Data": "通过英文双引号 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\""
								},
								{
									"Type": "NodeText",
									"Data": " 包裹起来的字符。其中如果需要使用 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\""
								},
								{
									"Type": "NodeText",
									"Data": " 本身，则可通过 SQL 风格转义（再加一个"
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\""
								},
								{
									"Type": "NodeText",
									"Data": "），例如 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\"foo\"\"bar\"\"\""
								},
								{
									"Type": "NodeText",
									"Data": " 将搜索命中 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "foo\"bar\""
								}
							]
						}
					]
				},
				{
					"ID": "20220415194739-jngjmqt",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415194739-jngjmqt",
						"updated": "20220415232543"
					},
					"Children": [
						{
							"ID": "20220415194739-bupb792",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415194739-bupb792",
								"updated": "20220415232543"
							},
							"Children": [
								{
									"Type": "NodeText",
									"Data": "由非 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "AND"
								},
								{
									"Type": "NodeText",
									"Data": "、"
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "OR"
								},
								{
									"Type": "NodeText",
									"Data": " 和 "
								},
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "NOT"
								},
								{
									"Type": "NodeText",
									"Data": " 字符组成，并且这些字符必须是："
								}
							]
						},
						{
							"ID": "20220415195209-5yhjye3",
							"Type": "NodeList",
							"ListData": {},
							"Properties": {
								"id": "20220415195209-5yhjye3"
							},
							"Children": [
								{
									"ID": "20220415195209-k7w0u65",
									"Type": "NodeListItem",
									"ListData": {
										"BulletChar": 42,
										"Marker": "Kg=="
									},
									"Properties": {
										"id": "20220415195209-k7w0u65"
									},
									"Children": [
										{
											"ID": "20220415195209-uselyqc",
											"Type": "NodeParagraph",
											"Properties": {
												"id": "20220415195209-uselyqc",
												"updated": "20220415195300"
											},
											"Children": [
												{
													"Type": "NodeText",
													"Data": "所有非 ASCII 字符，或者"
												}
											]
										}
									]
								},
								{
									"ID": "20220415195315-pabtfkj",
									"Type": "NodeListItem",
									"ListData": {
										"BulletChar": 42,
										"Marker": "Kg=="
									},
									"Properties": {
										"id": "20220415195315-pabtfkj"
									},
									"Children": [
										{
											"ID": "20220415195315-8xo8n7w",
											"Type": "NodeParagraph",
											"Properties": {
												"id": "20220415195315-8xo8n7w",
												"updated": "20220415195527"
											},
											"Children": [
												{
													"Type": "NodeText",
													"Data": "属于 52 个大小写英文字符（"
												},
												{
													"Type": "NodeTextMark",
													"TextMarkType": "code",
													"TextMarkTextContent": "A-Za-z"
												},
												{
													"Type": "NodeText",
													"Data": "），或者"
												}
											]
										}
									]
								},
								{
									"ID": "20220415195343-32719dk",
									"Type": "NodeListItem",
									"ListData": {
										"BulletChar": 42,
										"Marker": "Kg=="
									},
									"Properties": {
										"id": "20220415195343-32719dk"
									},
									"Children": [
										{
											"ID": "20220415195343-813xgm5",
											"Type": "NodeParagraph",
											"Properties": {
												"id": "20220415195343-813xgm5",
												"updated": "20220415195537"
											},
											"Children": [
												{
													"Type": "NodeText",
													"Data": "属于 10 个 ASCII 数字字符（"
												},
												{
													"Type": "NodeTextMark",
													"TextMarkType": "code",
													"TextMarkTextContent": "0-9"
												},
												{
													"Type": "NodeText",
													"Data": "），或者"
												}
											]
										}
									]
								},
								{
									"ID": "20220415195453-3jooj2k",
									"Type": "NodeListItem",
									"ListData": {
										"BulletChar": 42,
										"Marker": "Kg=="
									},
									"Properties": {
										"id": "20220415195453-3jooj2k"
									},
									"Children": [
										{
											"ID": "20220415195453-xcob0p8",
											"Type": "NodeParagraph",
											"Properties": {
												"id": "20220415195453-xcob0p8",
												"updated": "20220415195503"
											},
											"Children": [
												{
													"Type": "NodeText",
													"Data": "是下划线 "
												},
												{
													"Type": "NodeTextMark",
													"TextMarkType": "code",
													"TextMarkTextContent": "_"
												},
												{
													"Type": "NodeText",
													"Data": "，或者"
												}
											]
										}
									]
								},
								{
									"ID": "20220415195546-k0kd2dp",
									"Type": "NodeListItem",
									"ListData": {
										"BulletChar": 42,
										"Marker": "Kg=="
									},
									"Properties": {
										"id": "20220415195546-k0kd2dp"
									},
									"Children": [
										{
											"ID": "20220415195546-ovm4ei3",
											"Type": "NodeParagraph",
											"Properties": {
												"id": "20220415195546-ovm4ei3",
												"updated": "20220415195626"
											},
											"Children": [
												{
													"Type": "NodeText",
													"Data": "是替换符（ASCII 26）"
												}
											]
										}
									]
								}
							]
						}
					]
				}
			]
		},
		{
			"ID": "20220415202537-i16tvjh",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415202537-i16tvjh",
				"updated": "20220415202830"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "对于非上述的其他字符构成的字符串，必须使用 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "\""
				},
				{
					"Type": "NodeText",
					"Data": " 包裹起来，比如包含了 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "-"
				},
				{
					"Type": "NodeText",
					"Data": "、"
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "*"
				},
				{
					"Type": "NodeText",
					"Data": " 等符号的字符串。"
				}
			]
		},
		{
			"ID": "20220415192040-apqa2u0",
			"Type": "NodeHeading",
			"HeadingLevel": 2,
			"Properties": {
				"id": "20220415192040-apqa2u0",
				"updated": "20220415192043"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "短语"
				}
			]
		},
		{
			"ID": "20220415192311-5fv8kjl",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415192311-5fv8kjl",
				"updated": "20220415205041"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "短语由字符串构成，可由 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "+"
				},
				{
					"Type": "NodeText",
					"Data": " 进行连接。一个短语是由一些记号（Token）有序构成，这些记号由用户的输入文本通过分词器处理得到。思源使用的分词器为了让中文搜索好用（支持单字搜索），所以实现方式是按照字分词的（"
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "a",
					"TextMarkAHref": "https://github.com/siyuan-note/sqlite-fts5-siyuan-tokenizer",
					"TextMarkTextContent": "分词器代码"
				},
				{
					"Type": "NodeText",
					"Data": "），也就是说每个汉字或者英文字母都会被拆分为一个记号。这对 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "+"
				},
				{
					"Type": "NodeText",
					"Data": " 连接会产生一些影响，所以如果不确定的话，建议不要使用 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "+"
				},
				{
					"Type": "NodeText",
					"Data": " 组合多个短语。"
				}
			]
		},
		{
			"ID": "20220415192044-9d8ou1j",
			"Type": "NodeHeading",
			"HeadingLevel": 2,
			"Properties": {
				"id": "20220415192044-9d8ou1j",
				"updated": "20220415192101"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "查询"
				}
			]
		},
		{
			"ID": "20220415192101-lezi6pd",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415192101-lezi6pd",
				"updated": "20220415211942"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "查询由多个短语构成，可通过操作符 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "AND"
				},
				{
					"Type": "NodeText",
					"Data": "、"
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "OR"
				},
				{
					"Type": "NodeText",
					"Data": " 和 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "NOT"
				},
				{
					"Type": "NodeText",
					"Data": " 组合为新的查询。"
				}
			]
		},
		{
			"ID": "20220415211911-abpzhkl",
			"Type": "NodeTable",
			"TableAligns": [
				0,
				0
			],
			"Properties": {
				"colgroup": "|",
				"id": "20220415211911-abpzhkl",
				"updated": "20220415233018"
			},
			"Children": [
				{
					"Type": "NodeTableHead",
					"Data": "thead",
					"Children": [
						{
							"Type": "NodeTableRow",
							"Data": "tr",
							"Children": [
								{
									"Type": "NodeTableCell",
									"Data": "th",
									"Children": [
										{
											"Type": "NodeText",
											"Data": "操作符"
										}
									]
								},
								{
									"Type": "NodeTableCell",
									"Data": "th",
									"Children": [
										{
											"Type": "NodeText",
											"Data": "功能"
										}
									]
								}
							]
						}
					]
				},
				{
					"Type": "NodeTableRow",
					"Data": "tr",
					"Children": [
						{
							"Type": "NodeTableCell",
							"Data": "td",
							"Children": [
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\u003cquery1\u003e AND \u003cquery2\u003e"
								}
							]
						},
						{
							"Type": "NodeTableCell",
							"Data": "td",
							"Children": [
								{
									"Type": "NodeText",
									"Data": "query1 和 query2 同时匹配"
								}
							]
						}
					]
				},
				{
					"Type": "NodeTableRow",
					"Data": "tr",
					"Children": [
						{
							"Type": "NodeTableCell",
							"Data": "td",
							"Children": [
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\u003cquery1\u003e OR \u003cquery2\u003e"
								}
							]
						},
						{
							"Type": "NodeTableCell",
							"Data": "td",
							"Children": [
								{
									"Type": "NodeText",
									"Data": "query1 或者 query2 匹配"
								}
							]
						}
					]
				},
				{
					"Type": "NodeTableRow",
					"Data": "tr",
					"Children": [
						{
							"Type": "NodeTableCell",
							"Data": "td",
							"Children": [
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "\u003cquery1\u003e NOT \u003cquery2\u003e"
								}
							]
						},
						{
							"Type": "NodeTableCell",
							"Data": "td",
							"Children": [
								{
									"Type": "NodeText",
									"Data": "query1 匹配同时 query2 不匹配"
								}
							]
						}
					]
				}
			]
		},
		{
			"ID": "20220415212140-piktfs5",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415212140-piktfs5",
				"updated": "20220415212238"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "使用英文圆括号 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "()"
				},
				{
					"Type": "NodeText",
					"Data": " 可以组合查询的优先级，例如："
				}
			]
		},
		{
			"ID": "20220415212235-jon9dnr",
			"Type": "NodeCodeBlock",
			"IsFencedCodeBlock": true,
			"Properties": {
				"id": "20220415212235-jon9dnr",
				"updated": "20220502163519"
			},
			"Children": [
				{
					"Type": "NodeCodeBlockFenceOpenMarker",
					"Data": "```"
				},
				{
					"Type": "NodeCodeBlockFenceInfoMarker",
					"CodeBlockInfo": "c3Fs"
				},
				{
					"Type": "NodeCodeBlockCode",
					"Data": "-- 匹配包含 \"one\" 或者 \"two\" 的块，不匹配包含 \"three\" 的块\n'one OR two NOT three'\n\n-- 匹配包含 \"one\" 或者包含 \"two\" 且不包含 \"three\" 的块\n'one OR (two NOT three)'\n"
				},
				{
					"Type": "NodeCodeBlockFenceCloseMarker",
					"Data": "```"
				}
			]
		},
		{
			"ID": "20220415225818-8llyxls",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415225818-8llyxls",
				"updated": "20220415225927"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "使用空格分隔的多个短语默认使用 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "AND"
				},
				{
					"Type": "NodeText",
					"Data": " 连接，比如："
				}
			]
		},
		{
			"ID": "20220415225927-10jqrs9",
			"Type": "NodeCodeBlock",
			"IsFencedCodeBlock": true,
			"Properties": {
				"id": "20220415225927-10jqrs9",
				"updated": "20220502163531"
			},
			"Children": [
				{
					"Type": "NodeCodeBlockFenceOpenMarker",
					"Data": "```"
				},
				{
					"Type": "NodeCodeBlockFenceInfoMarker",
					"CodeBlockInfo": "c3Fs"
				},
				{
					"Type": "NodeCodeBlockCode",
					"Data": "'one two three'         -- 'one AND two AND three'\n'three \"one two\"'       -- 'three AND \"one two\"'\n'one OR two three'      -- 'one OR two AND three'\n\n'(one OR two) three'    -- 语法错误！\n'func(one two)'         -- 语法错误！\n"
				},
				{
					"Type": "NodeCodeBlockFenceCloseMarker",
					"Data": "```"
				}
			]
		},
		{
			"ID": "20220415195733-gb4mj1a",
			"Type": "NodeHeading",
			"HeadingLevel": 2,
			"Properties": {
				"id": "20220415195733-gb4mj1a",
				"updated": "20220415234700"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "技术实现"
				}
			]
		},
		{
			"ID": "20220415195737-mo3ya7g",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415195737-mo3ya7g",
				"updated": "20220415230645"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "我们通过 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "a",
					"TextMarkAHref": "https://www.sqlite.org/fts5.html",
					"TextMarkTextContent": "SQLite FTS5"
				},
				{
					"Type": "NodeText",
					"Data": " 实现了全局搜索。"
				}
			]
		},
		{
			"ID": "20220415200915-g1un9h6",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415200915-g1un9h6",
				"updated": "20220415200915"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "系统生成的查询语句关键部分大致是 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "MATCH '{content name alias memo}:\" + query"
				},
				{
					"Type": "NodeText",
					"Data": "，"
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "query"
				},
				{
					"Type": "NodeText",
					"Data": " 即用户输入部分，对于"
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "a",
					"TextMarkAHref": "https://www.sqlite.org/fts5.html#fts5_column_filters",
					"TextMarkTextContent": "列过滤器"
				},
				{
					"Type": "NodeText",
					"Data": " "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "code",
					"TextMarkTextContent": "{content name alias memo}:"
				},
				{
					"Type": "NodeText",
					"Data": " 是通过 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": "设置"
				},
				{
					"Type": "NodeText",
					"Data": " -"
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": " 搜索"
				},
				{
					"Type": "NodeText",
					"Data": " - "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": "属性"
				},
				{
					"Type": "NodeText",
					"Data": " 生成的。"
				}
			]
		},
		{
			"ID": "20220415200742-2l1tkjr",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415200742-2l1tkjr",
				"updated": "20220415202247"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "了解到这些以后，我们就可以通过查询语法来实现查询嵌入块，这样查询性能会更好："
				}
			]
		},
		{
			"ID": "20220415200953-ftnqiic",
			"Type": "NodeBlockQueryEmbed",
			"Properties": {
				"id": "20220415200953-ftnqiic",
				"updated": "20220415234532"
			},
			"Children": [
				{
					"Type": "NodeOpenBrace"
				},
				{
					"Type": "NodeOpenBrace"
				},
				{
					"Type": "NodeBlockQueryEmbedScript",
					"Data": "SELECT * FROM blocks_fts WHERE blocks_fts MATCH 'content:Query Syntax' AND root_id = '20220415190432-r3xqn3r' LIMIT 1"
				},
				{
					"Type": "NodeCloseBrace"
				},
				{
					"Type": "NodeCloseBrace"
				}
			]
		},
		{
			"ID": "20220415202144-mc7e5xh",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415202144-mc7e5xh",
				"updated": "20220415202331"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "除此以外，API 也支持使用 FTS 查询。"
				}
			]
		},
		{
			"ID": "20220415230035-u0oui0b",
			"Type": "NodeHeading",
			"HeadingLevel": 3,
			"Properties": {
				"id": "20220415230035-u0oui0b",
				"updated": "20220415230221"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "大小写敏感"
				}
			]
		},
		{
			"ID": "20220415230042-zzlr04p",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415230042-zzlr04p",
				"updated": "20220415230236"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "如果开启了 "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": "设置"
				},
				{
					"Type": "NodeText",
					"Data": " - "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": "搜索"
				},
				{
					"Type": "NodeText",
					"Data": " - "
				},
				{
					"Type": "NodeTextMark",
					"TextMarkType": "kbd",
					"TextMarkTextContent": "区分大小写"
				},
				{
					"Type": "NodeText",
					"Data": " 选项，则搜索会区分大小写，默认该选项是关闭的，即不区分大小写。"
				}
			]
		},
		{
			"ID": "20220415230602-jrrha1j",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415230602-jrrha1j",
				"updated": "20220415230942"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "由于分词器是区分大小写的，所以我们构建了两张虚拟表来分别索引："
				}
			]
		},
		{
			"ID": "20220415230020-e6368ni",
			"Type": "NodeList",
			"ListData": {},
			"Properties": {
				"id": "20220415230020-e6368ni",
				"updated": "20220415231331"
			},
			"Children": [
				{
					"ID": "20220415230947-ckedfb7",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415230947-ckedfb7",
						"updated": "20220415230947"
					},
					"Children": [
						{
							"ID": "20220415230947-wz2s44w",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415230947-wz2s44w",
								"updated": "20220415231012"
							},
							"Children": [
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "blocks_fts"
								},
								{
									"Type": "NodeText",
									"Data": "：按字符原样分词"
								}
							]
						}
					]
				},
				{
					"ID": "20220415230955-u91qki7",
					"Type": "NodeListItem",
					"ListData": {
						"BulletChar": 42,
						"Marker": "Kg=="
					},
					"Properties": {
						"id": "20220415230955-u91qki7",
						"updated": "20220415231331"
					},
					"Children": [
						{
							"ID": "20220415230955-x5pw61i",
							"Type": "NodeParagraph",
							"Properties": {
								"id": "20220415230955-x5pw61i",
								"updated": "20220415231331"
							},
							"Children": [
								{
									"Type": "NodeTextMark",
									"TextMarkType": "code",
									"TextMarkTextContent": "blocks_fts_case_insensitive"
								},
								{
									"Type": "NodeText",
									"Data": "：将英文字母转换为小写分词"
								}
							]
						}
					]
				}
			]
		},
		{
			"ID": "20220415231036-fa3a3bu",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415231036-fa3a3bu",
				"updated": "20220415231344"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "这样做的缺点是增加了磁盘空间占用和降低了索引性能，但是目前暂时没有更好的方案，所以只能先这样了。另外，不支持 Unicode 大小写折叠和变音符号，仅支持英文字母忽略大小写。"
				}
			]
		},
		{
			"ID": "20220415232054-zr76p9s",
			"Type": "NodeParagraph",
			"Properties": {
				"id": "20220415232054-zr76p9s",
				"updated": "20220415232120"
			},
			"Children": [
				{
					"Type": "NodeText",
					"Data": "如果你有更好的实现方案，欢迎告诉我们，非常感谢。"
				}
			]
		}
	]
}