Returns the same result as the EQUAL(=) for non-null operands, but returns true if both are NULL, false if one of the them is NULL.īetween, in, rlike, regexp, ilike, like, is, is distinct from Returns true if str does (not) match any/all patterns. Returns true if str does (not) match pattern with escape case-insensitively. Returns true if query returns at least one row, or false otherwise. Returns true if expr1 is greater than expr2, or false otherwise. Returns true if expr1 is greater than or equal to expr2, or false otherwise. Returns true if expr1 equals expr2, or false otherwise. Returns a STRUCT field by fieldIdentifier. Returns the integral part of the division of divisor by dividend. Returns fields extracted from the jsonStr.Ĭasts the value expr to the target data type type. Returns the bitwise exclusive OR (XOR) of expr1 and expr2. Returns inde圎xprnd element of ARRAY arrayExpr Tests whether expr1 is greater or equal than expr2 and less than or equal to expr3. Returns the logical NOT of a Boolean expression. Returns true if expr1 does not equal expr2, or false otherwise. Returns multiplier multiplied by multiplicand. Returns the logical AND of expr1 and expr2. Returns the bitwise AND of expr1 and expr2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |