![]() SQLite provides three built-in auxiliary functions that can be used within full-text queries on the FTS5 table. WHERE posts MATCH 'search AND (sqlite OR help)' Ĭode language: SQL (Structured Query Language) ( sql ) Built-in auxiliary functions To find the documents that match search and either sqlite or help, you use parenthesis as follows: SELECT * The statement returns documents that match search and sqlite or help. WHERE posts MATCH 'search AND sqlite OR help' To change the operator precedence, you use parenthesis to group expressions. WHERE posts MATCH 'sqlite AND searching' To find the documents that match both SQLite and searching, you use the AND operator as shown below: SELECT * To search for documents that match either phrase learn or text, you use the OR operator as the following example: SELECT *
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |