44,871
edits
MTL Toolbox: Difference between revisions
m
→Technical Notes
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. Similar to but not same as the {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]] | * Token prefix queries: use the asterisk ('*') at the end. Similar to but not same as the {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]] (normal wildcard search not currently supported by FTS) | ||
** Example: {{TE|Tai*oa*}} | ** Example: {{TE|Tai*oa*}} | ||
* Specify a column-name followed by a colon (':') | * Specify a column-name followed by a colon (':') | ||