A Like Query is one where a search for a value is performed with flanking wildcards.

build_query_like(
  fields = "*",
  distinct = FALSE,
  schema,
  table,
  where_like_field,
  where_like_value,
  case_insensitive = TRUE,
  limit_n = NULL
)

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.

See also