SQLite Operators

 SQLite Operators

• SQLite support unary prefix operators.
  1) – +
  2) ~
  3) NOT (for boolean expr..)
  4) || (for string concatenation)
  5) + – * / % (standerd arithmetic operators)
  6) | & << >> (bitwise operator or, and, shift-high,shift-low)
  7) < <= => > (Comparison test operator less-than, less-than or equal, greater-than or equal, greater-than)
  8) = == != <> (Equality test operator. = and == will test for equality while != and <> test for inequality.
  9) IN LIKE GLOB MATCH REGEXP(these are five keywords)
  10) AND OR (Logical operators)

swamios