What is the purpose of json_contains in MySQL?

In MySQL, the function json_contains is used to determine whether a JSON array or object contains a specified key or value. It takes two parameters: the JSON data being checked and the key or value to be checked.

To be more specific, the usage of the json_contains function is as follows:

Check if the specified value exists within the JSON data at the specified path.

This, json_data is the JSON data to be checked, which can be a JSON array or object; value is the key or value to be checked; path is an optional parameter used to specify the path to search in the JSON data.

The json_contains function returns 1 if the specified key or value exists in the JSON data; otherwise, it returns 0.