Built-In Function and Operator Reference 2102 Name Description Introduced Deprecated INTERVAL() Return the index of the argument that is less than the first argument IS Test a value against a boolean IS_FREE_LOCK() Whether the named lock is free IS_IPV4() Whether argument is an IPv4 address IS_IPV4_COMPAT() Whether argument is an IPv4-compatible address IS_IPV4_MAPPED() Whether argument is an IPv4-mapped address IS_IPV6() Whether argument is an IPv6 address IS NOT Test a value against a boolean IS NOT NULL NOT NULL value test IS NULL NULL value test IS_USED_LOCK() Whether the named lock is in use; return connection identifier if true IS_UUID() Whether argument is a valid UUID ISNULL() Test whether the argument is NULL JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON array JSON_ARRAYAGG() Return result set as a single JSON array JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document JSON_EXTRACT() Return data from JSON document JSON_INSERT() Insert data into JSON document