in_condition: Create SQL string to select values included in a set of given...
In UweBlock/lazysql: Lazy SQL Programming

Description Usage Arguments Details Value Author(s) See Also Examples

Create string with SQL IN expression for WHERE clause to select values included in a set of given values.

1	in_condition(column_name, choices, negation = c("", "not"))

`column_name`	[character(1)] Name of data base column to select values from.
`choices`	[character(1:Inf)] or [integer(1:Inf)] The values which must be matched. Character values must not contain any single or double quotes to avoid problems with SQL syntax and for safety reasons.
`negation`	[character(1)] If `"not"` the selection is inverted to a `NOT IN` expression.

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

valid_identifier_regex.

# 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")