Functions That Search JSON Values +-------------------------------+ | JSON_SEARCH(@j, ’all’, ’%a%’) | +-------------------------------+ | ["$[0]", "$[2].x"] | +-------------------------------+ +-------------------------------+ | JSON_SEARCH(@j, ’all’, ’%b%’) | +-------------------------------+ | ["$[0]", "$[2].x", "$[3].y"] | +-------------------------------+ +---------------------------------------------+ | JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[0]’) | +---------------------------------------------+ | "$[0]" | +---------------------------------------------+ +---------------------------------------------+ | JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[2]’) | +---------------------------------------------+ | "$[2].x" | +---------------------------------------------+ +---------------------------------------------+ | JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[1]’) | +---------------------------------------------+ | NULL | +---------------------------------------------+ +-------------------------------------------+ | JSON_SEARCH(@j, ’all’, ’%b%’, ’’, ’$[1]’) | +-------------------------------------------+ | NULL | +-------------------------------------------+ +-------------------------------------------+ | JSON_SEARCH(@j, ’all’, ’%b%’, ’’, ’$[3]’) | +-------------------------------------------+ | "$[3].y" | +-------------------------------------------+ mysql>  SELECT JSON_SEARCH(@j, ’all’, ’%b%’); mysql>  SELECT JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[0]’); mysql>  SELECT JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[2]’); mysql>  SELECT JSON_SEARCH(@j, ’all’, ’%b%’, NULL, ’$[1]’); mysql>  SELECT JSON_SEARCH(@j, ’all’, ’%b%’, ’’, ’$[1]’); mysql>  SELECT JSON_SEARCH(@j, ’all’, ’%b%’, ’’, ’$[3]’); JSON_VALUE( json_doc ,  path  [RETURNING  type ] [ on_empty ] [ on_error ]) on_empty : {NULL | ERROR | DEFAULT  value } ON EMPTY on_error : For more information about the JSON path syntax supported by MySQL, including rules governing the wildcard operators  *  and  ** , see JSON Path Syntax. 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 ) 2358