== (equals) operator

Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Filters a record set for data matching a case-sensitive string.

The following table provides a comparison of the == operators:

Operator	Description	Case-Sensitive	Example (yields `true`)
`==`	Equals	Yes	`"aBc" == "aBc"`
`!=`	Not equals	Yes	`"abc" != "ABC"`
`=~`	Equals	No	`"abc" =~ "ABC"`
`!~`	Not equals	No	`"aBc" !~ "xyz"`

For more information about other operators and to determine which operator is most appropriate for your query, see datatype string operators.

Performance tips

Note

Performance depends on the type of search and the structure of the data. For best practices, see Query best practices.

T | where col == (expression, ... )

Name	Type	Required	Description
T	`string`	✔️	The tabular input whose records are to be filtered.
col	`string`	✔️	The column to filter.
expression	`string`	✔️	The expression used to filter.

Returns the rows in T for which the predicate is true.

The following example returns the rows in the StormEvents table where the State column equals "kansas". This is a case-sensitive search.

StormEvents
| where State == "kansas"
| count

Count
0

The following example returns the rows in the StormEvents table where the State column equals "KANSAS". This is a case-sensitive search.

StormEvents
| where State == "KANSAS"
| count

Count
3,166