Changes between Initial Version and Version 1 of Ticket #36612


Ignore:
Timestamp:
Sep 16, 2025, 11:04:17 PM (4 weeks ago)
Author:
Jacob Tavener
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #36612 – Description

    initial v1  
    4545{{{#!div style="font-size: 80%"
    4646{{{#!sql
    47 JSON_UNQUOTE(JSON_EXTRACT(json_text, '$.key')) LIKE '%val%'
     47JSON_UNQUOTE(JSON_EXTRACT(CAST(json_text as json), '$.key')) LIKE '%val%'
    4848}}}
    4949}}}
     
    5757{{{#!div style="font-size: 80%"
    5858{{{#!sql
    59 json_text->>'$.key' LIKE '%val%'
     59CAST(json_text as json)->>'$.key' LIKE '%val%'
    6060}}}
    6161}}}
Back to Top