SQL: JSON_EXTRACT
12 August 2024 (Updated 18 May 2025)
Syntax:
select <columns>
from <table>
where json_extract(<column_with_json_data>, '$<json_path>')
Example:
select id, key_details
from client_report
where json_extract(key_details, '$.mortgages') > 0
Tagged:
SQL