Lines Matching refs:or
12 (in this case "t1"), or by the name of one of the columns of the fts3
33 query, a row (or column) of an Fts3 table must contain each of the specified
38 matches rows (or columns, if <col> is the name of a column name) that
41 quotation marks. In this case, a matching row or column must contain each
47 matches the first of the following two documents, but not the second or
55 may be used to search for rows that contain two or more specified tokens
56 or phrases within a specified proximity of each other. The NEAR operator
57 must always be specified in upper case. The word "near" in lower or mixed
65 they be seperated by only 10 tokens or less. The user may also specify
83 Similar to the NEAR operator, one or more tokens or phrases may be
85 or phrases must appear in the document. For example, the query:
89 matches rows that contain either the term "hello", or the term "world",
90 or both. Note that unlike in many programming languages, the OR operator
93 term 'sqlite' and at least one of the terms 'fantastic' or 'impressive',
94 not those that contain both 'sqlite' and 'fantastic' or 'impressive':
98 Any token that is part of an Fts3 query expression, whether or not it is
119 one term or phrase that is not preceded by the '-' prefix.
121 Regardless of whether or not a table name or column name is used on the
134 phrase or a term preceded by a '-' operator. A '*' character may be
160 in upper case. The word "and" specified in lower or mixed case is
203 tokens or phrases. Attempting the following query will return an error: