Answers for "join on JSON field"

Javascript

0

join on JSON field

SELECT 
       user.user_id, 
       user.user_name, 
       user_group.user_group_id,
       user_group.group_name
   FROM user
   LEFT JOIN user_group on JSON_CONTAINS(user.user_groups, CAST(user_group.user_group_id as JSON), '$')

Posted by: Guest on July-20-2021

Source

Code answers related to "join on JSON field"

Code answers related to "Javascript"

Javascript Answers by Framework

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#