Postgres query column with comma-delimited strings for array of strings
You need to convert the comma separated values to an array, then you can use the overlaps operator &amp;&amp;

select *
from pubnet
where string_to_array(oe, ',') &amp;&amp; array['F3DH19860AA', 'F4DHAA']