How to search by JSON in MariaDB?

Question

SQL

Hello! I have a table with records in my database (MariaDB), each record has a field with tags. The tags are written as a JSON array. It looks something like this:

id | tags
---+-------
1  | ["first", "second", "third"]
2  | ["first", "target", "second", "third"]
3  | ["foo", "bar"]

So, I need to select all records that, for example, will have "target" and "first" tags in the "tags" field. So that the result looks like this:

id | tags
---+-------
2  | ["first", "target", "second", "third"]

Question: How can this be done? And can I have an example?

Answer 1

https://mariadb.com/kb/en/json_search/

Answer 2

As far as I understand, it can be done like this:

"SELECT * FROM `table_name` WHERE JSON_CONTAINS(tags, '{\"target\", \"first\"}')"

The version of MariaDB that supports these features must be at least 10.2.3