Find rows where text array contains value similar to input
<p>I'm trying to get rows where a column of type <code>text[]</code> contains a value similar to some user input.</p>

<p>What I've thought and done so far is to use the <code>'ANY'</code> and <code>'LIKE</code>' operator like this:</p>

<pre><code>select * from someTable where '%someInput%' LIKE ANY(someColum);
</code></pre>

<p>But it doesn't work. The query returns the same values as that this query:</p>

<pre><code>select * from someTable where 'someInput' = ANY(someColum);
</code></pre>

<p>I've got good a result using the <code>unnest()</code> function in a subquery but I need to query this in <code>WHERE</code> clause if possible.</p>

<p><strong>Why</strong> doesn't the <code>LIKE</code> operator work with the <code>ANY</code> operator and I don't get any errors? I thought that one reason should be that <code>ANY</code> operator is in the right-hand of query, but ...</p>

<p>Is there any solution to this without using <code>unnest()</code> and if it is possible in <code>WHERE</code> clause?</p>