MTL Toolbox: Difference between revisions

m
Line 45: Line 45:
* [[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: {{TE|Taioa*}}
** Example: {{x|Taioa*}}
* Specify a column-name followed by a colon (':')
* Specify a column-name followed by a colon (':')
** Example: {{dft|thj:頭*}} (you should see all DFT entries starting with this Harnji)
** Example: {{dft|thj:頭*}} (you should see all DFT entries starting with this Harnji)
45,216

edits