Lines Matching refs:col
8 SELECT * FROM t1 WHERE <col> MATCH <full-text query>
11 The text "<col>" should be replaced by either the name of the fts3 table
36 <col> MATCH 'hello world'
38 matches rows (or columns, if <col> is the name of a column name) that
45 <col> MATCH '"hello world" joe"
60 <col> MATCH 'engineering NEAR consultancy'
69 <col> MATCH 'engineering NEAR/5 consultancy'
75 <col> MATCH 'reliable NEAR/2 engineering NEAR/5 consultancy'
87 <col> MATCH 'hello OR world'
96 <col> MATCH 'sqlite fantastic OR impressive'
104 <col> MATCH 'sql*'
113 <col> MATCH '"database engine" -sqlite'
125 is specified for <col>, the following query requires that column "col1"
131 <col> MATCH 'col1:hello col2:world'
146 <col> MATCH '(hello world) OR (simple example)'
157 <col> MATCH '(hello AND world) OR (simple AND example)'
170 <col> MATCH 'example NOT simple'
181 <col> MATCH 'sqlite fantastic OR impressive'
182 <col> MATCH '(sqlite AND fantastic) OR impressive'
186 <col> MATCH 'sqlite fantastic OR impressive'
190 <col> MATCH 'sqlite AND (fantastic OR impressive)'
205 <col> MATCH 'sqlite NEAR (fantastic OR impressive)'
209 <col> MATCH 'sqlite NEAR fantastic OR sqlite NEAR impressive'