What is the best way to search by json cell?

Question

PostgreSQL

I am writing a project on laravel, as a postgres database (I hope this will somehow help).
There is a field in the json table that stores an array in the form (array A) ['0', '12', '3']
And there is another array (array B) ['0', '5', '7']
And now you need to make a request, where at least one value from array B matches array A. You need to do it at the request level in the database, so as not to receive and not process unnecessary data.
What are the ways to do this?

Answer 1

SELECT *
FROM table
WHERE a::jsonb ?| ARRAY(SELECT json_array_elements_text(b))