Changes between Version 1 and Version 2 of Ticket #36612
- Timestamp:
- Sep 16, 2025, 11:05:36 PM (4 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #36612 – Description
v1 v2 45 45 {{{#!div style="font-size: 80%" 46 46 {{{#!sql 47 JSON_UNQUOTE(JSON_EXTRACT(CAST(json_text as json), '$.key')) LIKE '%val%' 47 LOWER(JSON_UNQUOTE(JSON_EXTRACT(CAST(json_text as json), '$.key'))) LIKE LOWER('%val%') 48 48 }}} 49 49 }}} … … 57 57 {{{#!div style="font-size: 80%" 58 58 {{{#!sql 59 CAST(json_text as json)->>'$.key' LIKE '%val%' 59 LOWER(CAST(json_text as json)) ->> '$.key' LIKE LOWER('%val%') 60 60 }}} 61 61 }}}