How to work with JSON in MYSQL?

In the tables the column `tags` in MDM so-called tags in json
[
"tag1",
"tag2",
"tag3"
]

Through the MYSQL query to do WHERE in accordance with the query to filter out tags such as a get request tags[]=tag1&tags[]=tag2
March 19th 20 at 08:23
1 answer
March 19th 20 at 08:25
WHERE JSON_CONTAINS(`tags`, '"tag1"') OR JSON_CONTAINS(`tags`, '"tag2"')

Find more questions by tags MySQL