Qore SqlUtil Module Reference 1.9.1
Loading...
Searching...
No Matches
SQL Operators

Variables

const SqlUtil::DefaultExpressionMap
 Default expressions to be supported by all SqlUtil modules.
 
const SqlUtil::DefaultOpMap
 a hash of valid operators for use in Where Clauses
 
const SqlUtil::OP_BETWEEN = "between"
 the SQL "between" operator for use in Where Clauses More...
 
const SqlUtil::OP_CEQ = "C="
 the SQL equals operator (=) for use in Where Clauses More...
 
const SqlUtil::OP_CGE = "C>="
 the SQL greater than or equals operator (>=) for use in Where Clauses More...
 
const SqlUtil::OP_CGT = "C>"
 the SQL greater than operator (>) for use in Where Clauses More...
 
const SqlUtil::OP_CLE = "C<="
 the SQL less than or equals (<=) operator for use in Where Clauses More...
 
const SqlUtil::OP_CLT = "C<"
 the SQL less than (<) operator for use in Where Clauses when comparing two columns More...
 
const SqlUtil::OP_CNE = "C!="
 the SQL not equals operator (!= or <>) for use in Where Clauses More...
 
const SqlUtil::OP_EQ = "="
 the SQL equals operator (=) for use in Where Clauses More...
 
const SqlUtil::OP_GE = ">="
 the SQL greater than or equals operator (>=) for use in Where Clauses More...
 
const SqlUtil::OP_GT = ">"
 the SQL greater than operator (>) for use in Where Clauses More...
 
const SqlUtil::OP_IN = "in"
 the SQL "in" operator for use in Where Clauses More...
 
const SqlUtil::OP_IN_SELECT = "in_select"
 the SQL "in" operator with a select query for use in Where Clauses More...
 
const SqlUtil::OP_LE = "<="
 the SQL less than or equals (<=) operator for use in Where Clauses More...
 
const SqlUtil::OP_LIKE = "like"
 
const SqlUtil::OP_LT = "<"
 the SQL less than (<) operator for use in Where Clauses More...
 
const SqlUtil::OP_NE = "!="
 the SQL not equals operator (!= or <>) for use in Where Clauses More...
 
const SqlUtil::OP_NOT = "not"
 the SQL "not" operator for use in Where Clauses More...
 
const SqlUtil::OP_OR = "or"
 to combine SQL expressions with "or" for use in Where Clauses More...
 
const SqlUtil::OP_SUBSTR = "substr"
 the SQL "substr" operator for use in Where Clauses More...
 

Detailed Description

These are the operators that can be used in where clauses; see Where Clauses for more information

Variable Documentation

◆ OP_BETWEEN

const SqlUtil::OP_BETWEEN = "between"

the SQL "between" operator for use in Where Clauses

See also
op_between()

◆ OP_CEQ

const SqlUtil::OP_CEQ = "C="

the SQL equals operator (=) for use in Where Clauses

See also
op_ceq()

◆ OP_CGE

const SqlUtil::OP_CGE = "C>="

the SQL greater than or equals operator (>=) for use in Where Clauses

See also
op_cge()

◆ OP_CGT

const SqlUtil::OP_CGT = "C>"

the SQL greater than operator (>) for use in Where Clauses

See also
op_cgt()

◆ OP_CLE

const SqlUtil::OP_CLE = "C<="

the SQL less than or equals (<=) operator for use in Where Clauses

See also
op_cle()

◆ OP_CLT

const SqlUtil::OP_CLT = "C<"

the SQL less than (<) operator for use in Where Clauses when comparing two columns

See also
op_clt()

◆ OP_CNE

const SqlUtil::OP_CNE = "C!="

the SQL not equals operator (!= or <>) for use in Where Clauses

See also
op_cne()

◆ OP_EQ

const SqlUtil::OP_EQ = "="

the SQL equals operator (=) for use in Where Clauses

See also
op_eq()

◆ OP_GE

const SqlUtil::OP_GE = ">="

the SQL greater than or equals operator (>=) for use in Where Clauses

See also
op_ge()

◆ OP_GT

const SqlUtil::OP_GT = ">"

the SQL greater than operator (>) for use in Where Clauses

See also
op_gt()

◆ OP_IN

const SqlUtil::OP_IN = "in"

the SQL "in" operator for use in Where Clauses

See also
op_in()

◆ OP_IN_SELECT

const SqlUtil::OP_IN_SELECT = "in_select"

the SQL "in" operator with a select query for use in Where Clauses

See also
op_in_select()

◆ OP_LE

const SqlUtil::OP_LE = "<="

the SQL less than or equals (<=) operator for use in Where Clauses

See also
op_le()

◆ OP_LIKE

const SqlUtil::OP_LIKE = "like"

the SQL "like" operator for use in Where Clauses

See also
op_like()

◆ OP_LT

const SqlUtil::OP_LT = "<"

the SQL less than (<) operator for use in Where Clauses

See also
op_lt()

◆ OP_NE

const SqlUtil::OP_NE = "!="

the SQL not equals operator (!= or <>) for use in Where Clauses

See also
op_ne()

◆ OP_NOT

const SqlUtil::OP_NOT = "not"

the SQL "not" operator for use in Where Clauses

See also
op_not()

◆ OP_OR

const SqlUtil::OP_OR = "or"

to combine SQL expressions with "or" for use in Where Clauses

See also
wop_or()

◆ OP_SUBSTR

const SqlUtil::OP_SUBSTR = "substr"

the SQL "substr" operator for use in Where Clauses

See also
op_substr()