R Graphical Manual

Browse All

Last data update: 2014.03.03

R: Create SQL string to select values included in a set of given...

in_condition

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)] 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.

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

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