MTL Toolbox: Difference between revisions

1 byte removed ,  08:50, 9 April 2023
m
mNo edit summary
Line 28: Line 28:
* 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]] (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|Tai*oa*}}
** Example: {{TE|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