45,015
edits
MTL Toolbox: Difference between revisions
m
→Technical notes
m (→Monosyllable) |
|||
| Line 47: | Line 47: | ||
* [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search | * [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search | ||
* 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: {{x|Taioa*}} | ** Example: {{x|Taioa*}}, {{x|臺*}} | ||
* Specify a column-name followed by a colon (':') | * Specify a column-name followed by a colon (':') | ||
** Example: {{x|thj:頭*}} (returns entries where Taiwanese written with Harnji begins with character for [[thaau]]) | ** Example: {{x|thj:頭*}} (returns entries where Taiwanese written with Harnji begins with character for [[thaau]]) | ||