in_condition {lazysql} | R Documentation |
Create string with SQL IN
expression for WHERE
clause to select values
included in a set of given values.
in_condition(column_name, choices, negation = c("", "not"))
column_name |
[character(1)] |
choices |
[character(1:Inf)] or [integer(1:Inf)] |
negation |
[character(1)] |
column_name
must be a valid SQL identifier. It is validated to conform to
the regular expression returned by valid_identifier_regex
.
Character string to be used in SQL statement.
Uwe Block
# SQL expressions
lazysql::in_condition("COL_1", 1:3)
lazysql::in_condition("COL_1", 1:3, "not")
lazysql::in_condition("COL_1", LETTERS[2:3])
lazysql::in_condition("COL_1", LETTERS[2:3], "not")