48,120
edits
m (→How to perform a full-text search: order) |
m ({{TE| -> {{te|) |
||
| Line 67: | Line 67: | ||
Our full-text search is provided by the [[SQLite]] [https://sqlite.org/fts3.html FTS4] extension. We currently use the Standard Query Syntax. One of the three basic query types supported by FTS tables is "token or token prefix queries": | Our full-text search is provided by the [[SQLite]] [https://sqlite.org/fts3.html FTS4] extension. We currently use the Standard Query Syntax. One of the three basic query types supported by FTS tables is "token or token prefix queries": | ||
* Specify a token prefix by appending an asterisk ('*') to the prefix. (While similar to {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]], wildcard search is not currently supported by FTS) | * Specify a token prefix by appending an asterisk ('*') to the prefix. (While similar to {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]], wildcard search is not currently supported by FTS) | ||
** Example: {{ | ** Example: {{te|Taioa*}}, {{te|臺*}} | ||
* Specify a column-name followed by a colon (':') | * Specify a column-name followed by a colon (':') | ||
** Example: {{ | ** Example: {{te|hj:頭*}} (returns entries where Taiwanese written with Harnji begins with character for [[thaau]]) | ||
* Prefix the token with carat ('^') to require token to be very first token in its column | * Prefix the token with carat ('^') to require token to be very first token in its column | ||
** Example: {{ | ** Example: {{te|^thaau}} | ||
Tokenizer: the default tokenizer ("simple") is used. Because it only does case folding of [[ASCII]] characters, [[Ø]] and ø do not match each other. Some words starting with Ø include {{ | Tokenizer: the default tokenizer ("simple") is used. Because it only does case folding of [[ASCII]] characters, [[Ø]] and ø do not match each other. Some words starting with Ø include {{te|Ørciw}}, {{te|Ørmngg}}, and {{te|Ørtøexli}}. | ||
== See also == | == See also == | ||
edits