Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add documentation for the "^" qualifier to fts3.html. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
6a74a13c863983ca70539ea159f66719 |
User & Date: | dan 2014-07-07 10:39:31.415 |
Context
2014-07-07
| ||
13:13 | Clarification of the automerge documentation in FTS3. (check-in: a8e5cf50a0 user: drh tags: trunk) | |
10:39 | Add documentation for the "^" qualifier to fts3.html. (check-in: 6a74a13c86 user: dan tags: trunk) | |
2014-07-03
| ||
11:15 | Fix a typo in vtab.html. (check-in: 34e181958c user: dan tags: trunk) | |
Changes
Changes to pages/fts3.in.
︙ | ︙ | |||
554 555 556 557 558 559 560 561 562 563 564 565 566 567 | <i>-- Query the database for documents for which the term "linux" appears in</i> <i>-- the document title, and the term "driver" appears in the body of the document</i> <i>-- ("driver" may also appear in the title, but this alone will not satisfy the</i>. <i>-- query criteria).</i> SELECT * FROM docs WHERE body MATCH 'title:linux driver'; </codeblock> <tcl>hd_fragment phrase {phrase queries}</tcl> <ul> <li><p><b>Phrase queries</b>. A phrase query is a query that retrieves all documents that contain a nominated set of terms or term prefixes in a specified order with no intervening tokens. Phrase queries are specified by enclosing a space separated sequence of terms or term prefixes in double quotes ("). | > > > > > > > > > > > > > > > > | 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 | <i>-- Query the database for documents for which the term "linux" appears in</i> <i>-- the document title, and the term "driver" appears in the body of the document</i> <i>-- ("driver" may also appear in the title, but this alone will not satisfy the</i>. <i>-- query criteria).</i> SELECT * FROM docs WHERE body MATCH 'title:linux driver'; </codeblock> <ul> <li style="list-style:none"><p> If the FTS table is an FTS4 table (not FTS3), a token may also be prefixed with a "^" character. In this case, in order to match the token must appear as the very first token in any column of the matching row. Examples: </ul> <codeblock> <i>-- All documents for which "linux" is the first token of at least one</i> <i>-- column.</i> SELECT * FROM docs WHERE docs MATCH '^linux'; <i>-- All documents for which the first token in column "title" begins with "lin".</i> SELECT * FROM docs WHERE body MATCH 'title: ^lin*'; </codeblock> <tcl>hd_fragment phrase {phrase queries}</tcl> <ul> <li><p><b>Phrase queries</b>. A phrase query is a query that retrieves all documents that contain a nominated set of terms or term prefixes in a specified order with no intervening tokens. Phrase queries are specified by enclosing a space separated sequence of terms or term prefixes in double quotes ("). |
︙ | ︙ |