Postgres query to select all records that have at least one matching array value from another array
&quot;At least one match&quot; can be done using the &quot;overlaps&quot; operator &amp;&amp;
select *
from content
where related_content_ids &amp;&amp; '{fbaa1235-1069-496f-9a54-e91e13aadae8,65a109eb-ee4b-4a23-9f91-6980b5bb9340}'