Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add documentation for the "^" qualifier to fts3.html. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
6a74a13c863983ca70539ea159f66719 |
| User & Date: | dan 2014-07-07 10:39:31 |
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 (").
|