MTL Toolbox: Difference between revisions

Jump to navigation Jump to search
56 bytes added ,  13:09, 4 August 2022
m
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 (':')
45,377

edits

Navigation menu