in_condition {lazysql} | R Documentation |
Create SQL string to select values included in a set of given values
Description
Create string with SQL IN
expression for WHERE
clause to select values
included in a set of given values.
Usage
in_condition(column_name, choices, negation = c("", "not"))
Arguments
column_name |
[character(1)] |
choices |
[character(1:Inf)] or [integer(1:Inf)] |
negation |
[character(1)] |
Details
column_name
must be a valid SQL identifier. It is validated to conform to
the regular expression returned by valid_identifier_regex
.
Value
Character string to be used in SQL statement.
Author(s)
Uwe Block
See Also
Examples
# 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")
[Package lazysql version 0.1.3 Index]