Re: [sqlite] SQL command not equal comparison within json content

On 2018/02/28 3:34 PM, tj5527 wrote: I create a table with the command `CREATE TABLE test1 (key text primary key, obj json);` with two records inserted # select * from test1; key1|{"a":1,"b":2,"c":{"x":99},"status":"done"} # record 1 key2|{ "key": key2 } # record 2 Now I want

Re: [sqlite] SQL command not equal comparison within json content

On 02/28/2018 08:34 PM, tj5527 wrote: I create a table with the command `CREATE TABLE test1 (key text primary key, obj json);` with two records inserted # select * from test1; key1|{"a":1,"b":2,"c":{"x":99},"status":"done"} # record 1 key2|{ "key": key2 } # record 2 The second

[sqlite] SQL command not equal comparison within json content

I create a table with the command `CREATE TABLE test1 (key text primary key, obj json);` with two records inserted # select * from test1; key1|{"a":1,"b":2,"c":{"x":99},"status":"done"} # record 1 key2|{ "key": key2 } # record 2 Now I want to retrieve the record that is not marked