MySQL_GetJSONValue

A value of a JSON cell as a string. An object or an array is written as JSON.

A value that does not exist or is null leaves value as it was.

native bool:MySQL_GetJSONValue(row, const field[], const key[], value[], size = sizeof (value));

Parameters

Parameter	Description	Default
row	The row, from 0.
const field[]	Name of the field.
const key[]	Member of the top object or a JSON Pointer.
value[]	Array for the text.
size	Size of the array.	sizeof (value)

Returns

• true when the text was written.
• false when the value does not exist or is null.

Remarks

A string gives its text. Any other value gives its JSON, so an object or an array can be read whole. With the latin1 character set, the text is converted from UTF-8 to the code page of the game, escaped letters such as \u00e7 included.

Related

• MySQL_GetJSONKey: The name of a member of an object of a JSON cell, by its position.
• MySQL_GetJSONType: The type of a value of a JSON cell.