Functions - 14paxton/SQLNotes GitHub Wiki

title: Functions
permalink: SQLNotes/Functions
category: SQLNotes
parent: SQLNotes
layout: default
has_children: false
share: true
shortRepo:

  • sqlnotes
  • default

Table of contents {: .text-delta } 1. TOC {:toc}


MySQL

extract JSON

select JSON_EXTRACT(app_metadata, '$.tb5', '$.tb6.roleGroups') as "all",              
       JSON_EXTRACT(app_metadata, '$.tb5."roleGroups"')        as "tb5"              
from user;
Add a custom footer
⚠️ **GitHub.com Fallback** ⚠️