46,004
edits
MTL Toolbox: Difference between revisions
m
→Technical notes: {{TE
m (→Other fields) |
m (→Technical notes: {{TE) |
||
| Line 55: | Line 55: | ||
* [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search (Standard Query Syntax) | * [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search (Standard Query Syntax) | ||
* Token prefix queries: use the asterisk ('*') at the end. Similar to {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]] (normal wildcard search not currently supported by FTS) | * Token prefix queries: use the asterisk ('*') at the end. Similar to {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]] (normal wildcard search 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]]) | ||
* Add carat ^ before token to require token to be very first token in its column | * Add carat ^ before token to require token to be very first token in its column | ||
** Example: {{ | ** Example: {{TE|^thaau}} | ||
* [[Ø]] is not folded to lower case by the tokenizer | * [[Ø]] is not folded to lower case by the tokenizer | ||