45,216
edits
MTL Toolbox: Difference between revisions
m
→Technical Notes: wildcard
m (→Technical Notes: wildcard) |
|||
| Line 26: | Line 26: | ||
== Technical Notes == | == Technical Notes == | ||
* FTS4 full-text searches: [https://sqlite.org/fts3.html SQLite FTS3 and FTS4 Extensions] | * FTS4 full-text searches: [https://sqlite.org/fts3.html SQLite FTS3 and FTS4 Extensions] | ||
* Token prefix queries: use the asterisk ('*') at the end | * Token prefix queries: use the asterisk ('*') at the end. Similar to but not same as the {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]] | ||
** Example: {{TE| | ** Example: {{TE|Tai*oa*}} | ||
* 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) | ||