Extract values from JSON data using json_value() Sql – single query

json_value

Extract values from JSON data using json_value() Sql – single query

How to extract values from json field using JSON_VALUE() in SQL

We can extract a scalar value from json string in sql SELECT query.

Syntax :

JSON_VALUE ( expression ,[Path Mode] JSON_path )

  • Expression: This is the table field/column name or a variable that contains json values. It should be a valid expression, and else it returns an error
  • JSON_Path: It is the location of a scalar value in the JSON string
  • Path mode:  We can specify the lax or strict value in this mode. It uses LAX as a default path mode. We will understand it using examples. It is an optional argument.

Query Example :

SELECT json_value(json_field,'$.title') AS title FROM json_sample;

Output :

This will return value of the key title from the json string stored in json_field

Click here to know more details about sql json values

To get more SQL solutions please visit MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top