Built-In Function and Operator Reference 2096 Name Description Introduced Deprecated ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a  SET  statement, or as part of the  SET  clause in an  UPDATE  statement) = Equal operator ^ Bitwise XOR ABS() Return the absolute value ACOS() Return the arc cosine ADDDATE() Add time values (intervals) to a date value ADDTIME() Add time AES_DECRYPT() Decrypt using AES AES_ENCRYPT() Encrypt using AES AND ,  && Logical AND ANY_VALUE() Suppress ONLY_FULL_GROUP_BY value rejection ASCII() Return numeric value of left-most character ASIN() Return the arc sine ATAN() Return the arc tangent ATAN2() ,  ATAN() Return the arc tangent of the two arguments AVG() Return the average value of the argument BENCHMARK() Repeatedly execute an expression BETWEEN ... AND ... Whether a value is within a range of values BIN() Return a string containing binary representation of a number BIN_TO_UUID() Convert binary UUID to string BINARY Cast a string to a binary string