> For the complete documentation index, see [llms.txt](https://docs.fylr.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fylr.io/for-users/search-and-filter/full-text-search.md). # Full Text Search Full-text search provides several options to **precisely define search queries** and narrow down results. The following features can be used **individually or combined**, depending on your use case. When typing a word into the search field, you get suggestions where you can pick from or simply continue writing (for more details see below):

OPTION	EXPLANATION
Fulltext	Automatically adds wildcards left and right. Example: `turm`
Exact Match	A case-sensitive search that only finds records where the whole value of a field match. Example: `Fernsehturm`
Word Suggestions	Shows words from the index and searches without wildcards. Example: `'Berlin'`
Lists	Shows entries from lists, vocabularies and thesauri.

### Searching for a Specific Word #### Case Sensitivity By default, full-text search is **case-insensitive**. This means that search results are returned regardless of capitalization. Examples: * `report`, `Report`, and `REPORT` return the same results. * Searching for `programmfabrik` also matches `Programmfabrik`. A case-sensitive search is only possible with the exact search (see below). #### Word Search The **word search** allows you to search for **exact word matches** across all searchable fields. The search is **not case-sensitive** and finds records where the specified word appears **anywhere within a text**, as long as it matches the complete word. You can select a word directly from the **autocomplete suggestions**, or you can manually enter a word by enclosing it in **single quotes**, for example `'automobile'`. Using single quotes ensures that the term is treated as a whole word rather than part of a longer string. #### Exact Search The **exact search** allows you to find records where a specific field matches **exactly** the search term you enter. This type of search is **case-sensitive** and does not return partial matches or variations (add wildcards to achieve this). If the field contains `fylr documentation`:

Search Term	Result
`FYLR`	❌ No match
`fylr documentation`	✅ Match
`documentation`	❌ No match
`Fylr Documentation`	❌ No match
`fylr*`	✅ Match

### Phrase Search Phrase search allows you to search for an **exact sequence of words**. The words must appear in the specified order and directly next to each other. To perform a phrase search, enclose the phrase in **quotation marks**. Example: ``` "Berliner Fernsehturm" ``` This search returns only records where the complete phrase appears exactly as entered. **Notes:** * Case sensitivity is ignored. * No additional words may appear between the phrase terms. * Phrase search is especially useful for quotes, fixed expressions, or known text fragments. ### Boolean Operators Boolean operators allow you to logically combine multiple search terms.

KEY	SEARCH OPERATOR	EXPLANATION
`-` or `!`	NOT	The following search term is searched with “Not”.
`+`	AND	The following search term is combined with “And”.
`,`	OR	The following search term is combined with “Or”.
`(`	`(`	Parenthesis for logical groupings.
`)`	`)`	Parenthesis for logical groupings.

#### AND The **AND** operator returns only records that contain **all** specified terms. It is not necessary to use the **AND** operator explicitly. By default, all search terms are automatically combined using an implicit **AND**. Therefore, records will only be returned if they contain all specified terms. Example: ``` contract AND termination ``` Result: Only records containing both *contract* and *termination*. #### OR The **OR** operator returns records that contain **at least one** of the specified terms. Example: ``` invoice OR receipt ``` Result: Records containing *invoice*, *receipt*, or both. #### NOT The **NOT** operator excludes records that contain a specific term. Example: ``` report NOT draft ``` Result: Records that contain *report* but **not** *draft*. #### Combining and Grouping Operators Boolean operators can be combined and grouped using parentheses. Example: ``` (contract OR agreement) AND termination ``` ### Wildcard Search Wildcard search allows you to find terms when parts of the word are unknown or variable. #### Single-Character Wildcard (?) The question mark `?` represents **exactly one arbitrary character**. Example: ``` Ma?er ``` Matches, for example: * Mayer * Maier * Mauer **Notes:** * Each `?` replaces exactly one character. * Multiple `?` characters can be used within a single term. #### Multi-Character Wildcard (\*) The asterisk `*` represents **zero, one, or multiple characters**. Examples: ``` Auto* ``` Matches: * Auto * Automatic * Automobile ``` *report ``` Matches: * annualreport * auditreport **Notes:** * The `*` wildcard can be used at the beginning, middle, or end of a word. * Searches with a leading `*` may impact performance. ## Others To search for a question within a text or word, use: ``` `*\?*` ``` To search for other characters within a text or word, use: ``` `*~*` ```