# Search operators

FuseQL search operators enable both regular and advanced log search (after you choose the **Advanced Search** option). The language specifies the following syntactical rules:

- The search operator must appear before the first pipe (`|`) symbol in the query expression.
- All other operators must follow a valid search expression.

## Operators

### [and](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#and)
Intersection operator (AND logic) between two search operators. Selects results that satisfy both conditions.

### [or](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#or)
Union operator (OR logic) between two search operators. Selects results that satisfy either or both conditions.

### [equal, `=`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#equal)
Searches for specified value; exact match.

### [not equal, `!=`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#not-equal)
Searches for values _**other**_ than the specified value; exact match.

### [greater than, `>`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#greater-than)
Searches for values that are greater than the specified number.

### [greater than or equal, `>=`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#greater-than-or-equal)
Searches for values that are greater than or equal to the specified number.

### [less than, `<`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#less-than)
Searches for values that are less than the specified number.

### [less than or equal, `<=`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#less-than-or-equal)
Searches for values that are less than or equal to the specified number.

### [regex, `=~`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#regex)
Searches for results that match a specific character pattern.

### [not regex, `!~`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#not-regex)
Searches for results that **_do not_** match a specific character pattern.

### [terms exist, `term`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#terms-exist)
Searches to match a specific term; limited to one word.

### [not terms exist, `!term`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#not-terms-exist)
Searches to exclude a specific term; limited to one word.

### [grep, `"grep"`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#grep)
Searches for a specific expression (multi-word string) in the log message body.

### [not grep, `!"grep"`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#not-grep)
Searches to exclude a specific expression (multi-word string) in the log message body.

### [facet terms exist, `==`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#facet-terms-exist)
Searches to match a specific facet and its value.

### [facet terms not exist, `!==`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#facet-terms-not-exist)
Searches to exclude a specific facet and its value.

### [starts with, `*~`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#starts-with)
Searches for labels or facets where the value begins with the specified string.

### [ends with, `~*`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#ends-with)
Searches for labels or facets where the value ends with the specified string.

### [contains, `**`](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#contains)
Searches for labels or facets where the value contains the specified string.

### [key exists](https://docs.kloudfuse.com/platform/3.5.0/fuseql-search-operators/#key-exists)
Searches for the presence of a specific facet, regardless of its value.

## Examples of Syntax

### and, `and`

Examples:

- Regular search:
    ```none
    facetName1="value1" facetName2="value2"
    ```
- Advanced search:
    ```none
    @facetName1="value1" and @facetName2="value2"
    ```

### or, `or`

Examples:

- Regular search:
    ```none
    @facet="valueA OR valueB"
    ```
- Advanced search:
    ```none
    @facet="valueA" or @facet="valueB"
    ```

### equal, `=`

Examples:

- Regular search:
    ```none
    label="value"
    ```
- Advanced search:
    ```none
    @facetName="value"
    ```

## Conclusion

For each operator, remember to select the correct syntax based on whether you are performing a regular or advanced search.