How to get records whose json field includes at least one value from the passed ones?

Question

PostgreSQL

As from the view table:

id|name|json_data
1|vasya|{"tags": ["a", "b", "c"]}
2|lena|{"tags":["d", "e", "f"]}
3|dima|{"tags": ["x", "y", "z"]}

Get sample:

id|name|json_data
1|vasya|{"tags": ["a", "b", "c"]}
3|dima|{"tags": ["x", "y", "z"]}

SELECT * FROM table WHERE "table"."json_data" ??? '{"tags":["a", "b", "c", "y"]}';

That is, all intersections with at least one element of the passed array.

Answer 1

SELECT * FROM `table` WHERE CONTAINS(`json_data`, '"*a*" OR "*b*" OR "*c*" OR "*y*"')

Answer 2

If I understand correctly, then the DLS-2500U works for you as a DHCP server. So you need to configure Keenetic Omni as an access point, and it must receive the Internet via IPoE (direct connection). One of the first articles on Google is rudevice.ru/zyxel/zyxel-keenetic-omni. The setting is covered in "NAT when automatically obtaining an IP address (DHCP)".