MTL Toolbox: Difference between revisions

m
Line 40: Line 40:


== Technical Notes ==
== Technical Notes ==
* FTS4 full-text searches: [https://sqlite.org/fts3.html SQLite FTS3 and FTS4 Extensions]
* [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search
* 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)
* 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|Taioa*}}
** Example: {{TE|Taioa*}}
44,871

edits