Beispiel für Json_extract (SQLite)

select distinct json_extract(coordinates, ‚$.longitude‘) AS long,json_extract(coordinates, ‚$.latitude‘) AS lat from twitter where coordinates not null limit 10

Kommentare sind deaktiviert.