Build a Regex Query

Build a query that searches for a regular expression.

build_query_regex(
  fields = "*",
  distinct = FALSE,
  schema,
  table,
  where_regex_field,
  regex,
  invert = FALSE,
  case_insensitive = TRUE,
  limit,
  random
)

Arguments

fields	Fields selected for. Defaults to "*".
distinct	If TRUE, the distinct row count will be returned.
schema	The target schema for the operation.
table	Target table for the operation.
case_insensitive	If TRUE, both sides of the query are converted to lowercase.
limit	(Optional) Integer of the row limit. Takes precedence over `random` if both arguments are provided.
random	(Optional) Integer of the random number of rows to return. Is preceded by `limit` if both `limit` and `random` are provided.

Arguments

See also