MTL Toolbox: Difference between revisions

Jump to navigation Jump to search
m
→‎Technical notes: Standard Query Syntax
m (→‎Technical notes: Standard Query Syntax)
Line 53: Line 53:


== Technical notes ==
== Technical notes ==
* [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search
* [[SQLite]]: [https://sqlite.org/fts3.html FTS4] for full-text search (Standard Query Syntax)
* Token prefix queries: use the asterisk ('*') at the end. Similar to {{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 {{w|wildcard character}} in [[zokgiap hexthorng|operating systems]] (normal wildcard search not currently supported by FTS)
** Example: {{x|Taioa*}}, {{x|臺*}}
** Example: {{x|Taioa*}}, {{x|臺*}}
45,664

edits

Navigation menu