3 ms·
> SELECT cars->>'model' FROM cars Can ‘model’ be a variable, or does it have to be a constant literal?
by mr_toad 1y ago
> SELECT cars->>'model' FROM cars
Can ‘model’ be a variable, or does it have to be a constant literal?
- CGamesPlay 1y agoIt’s any expression, so a parameter or shudder column would work. https://sqlite.org/json1.html#jptr https://sqlite.org/json1.html#jptr