Functions

---

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;