search

Full-text search across all string columns in the input table. Returns rows containing the search term.

Syntax

search term

Case-insensitive search across all columns

Name	Description
term	Text to search for across all string columns

search kind=mode term

Search with case sensitivity mode

Name	Description
term	Text to search for

Case sensitivity mode

Value	Description
`case_insensitive`	Default. Case-insensitive matching.
`case_sensitive`	Case-sensitive matching.

datatable(warrior:string, homeland:string)[
  "Ragnar", "Kattegat",
  "Rollo", "Normandy",
  "Bjorn", "Kattegat"
]
| search "Kattegat"

$table (string)	warrior (string)	homeland (string)
	Bjorn	Kattegat
	Ragnar	Kattegat

datatable(raid:string, target:string)[
  "Spring raid", "Lindisfarne",
  "Summer raid", "York"
]
| search target == "Lindisfarne"

$table (string)	raid (string)	target (string)
	Spring raid	Lindisfarne