content_image/849994.jpg content_image/849995.jpg content_image/849996.jpg content_image/849997.jpg content_image/849998.jpg content_image/849999.jpg content_image/850000.jpg
<img src='content_image/849994.jpg'>

mysql> SELECT JSON_SEARCH(@j, ’all’, ’%b%’); 

<img src='content_image/849995.jpg'>

mysql> SELECT JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[0]’); 

<img src='content_image/849996.jpg'>

mysql> SELECT JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[2]’); 

<img src='content_image/849997.jpg'>

mysql> SELECT JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[1]’); 

<img src='content_image/849998.jpg'>

mysql> SELECT JSON_SEARCH(@j, ’all’, ’%b%’, ’’, ’$[1]’); 

<img src='content_image/849999.jpg'>

mysql> SELECT JSON_SEARCH(@j, ’all’, ’%b%’, ’’, ’$[3]’); 

<img src='content_image/850000.jpg'>

For more information about the JSON path syntax supported by MySQL, including rules governing the wildcard operators *  and ** , see JSON Path Syntax. 

• JSON_VALUE( json_doc , path ) 

Extracts a value from a JSON document at the path given in the specified document, and returns the extracted value, optionally converting it to a desired type. The complete syntax is shown here: 

JSON_VALUE( json_doc , path  [RETURNING type ] [ on_empty ] [ on_error ]) on_empty : {NULL | ERROR | DEFAULT value } ON EMPTY on_error : 

