Built-In Function and Operator Reference Name Description Introduced Deprecated JSON_SET() Insert data into JSON document JSON_STORAGE_FREE() Freed space within binary representation of JSON column value following partial update JSON_STORAGE_SIZE() Space used for storage of binary representation of a JSON document JSON_TABLE() Return data from a JSON expression as a relational table JSON_TYPE() Type of JSON value JSON_UNQUOTE() Unquote JSON value JSON_VALID() Whether JSON value is valid JSON_VALUE() Extract value from JSON document at location pointed to by path provided; return this value as VARCHAR(512) or specified type 8.0.21 LAG() Value of argument from row lagging current row within partition LAST_DAY Return the last day of the month for the argument LAST_INSERT_ID() Value of the AUTOINCREMENT column for the last INSERT LAST_VALUE() Value of argument from last row of window frame LCASE() Synonym for LOWER() LEAD() Value of argument from row leading current row within partition LEAST() Return the smallest argument LEFT() Return the leftmost number of characters as specified LENGTH() Return the length of a string in bytes LIKE Simple pattern matching 2104