MySQL_GetJSONType

The type of a value of a JSON cell.

native MYSQL_JSON:MySQL_GetJSONType(row, const field[], const key[] = "");

Parameters

Parameter	Description	Default
row	The row, from 0.
const field[]	Name of the field.
const key[]	Member of the top object, a JSON Pointer, or empty for the whole value.	""

Returns

• The type.
• MYSQL_JSON_NONE when the value does not exist or the cell is not JSON.

Remarks

The types are listed in JSON types. A cell that is not JSON, and a key the cell does not have, are MYSQL_JSON_NONE. See JSON cells for keys and pointers.

Related

• MySQL_GetJSONCount: How many members an object of a JSON cell has, or how many elements an array has.
• MySQL_GetJSONString: A value of a JSON cell as a string. An object or an array is written as JSON.