Documentation Source Text

Check-in [6a74a13c86]
Login

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: 6a74a13c863983ca70539ea159f6671985cf688c
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
Unified Diff Ignore Whitespace Patch
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 "&#94;" 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 '&#94;linux';

  <i>-- All documents for which the first token in column "title" begins with "lin".</i>
  SELECT * FROM docs WHERE body MATCH 'title: &#94;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 (").