SQL : matching string of one column to substring of another table column
<p>I have two table t1 and t3. And I need t3 which has t1 string if t1 string is present in t2 string.</p>

<pre><code>t1-[mango, apple, Top]
t2-[{Ate mango}, {it was nice apple},{you are hero}, {apple shares top}] 
</code></pre>

<p>if string of t1 matches the substring of t2 then t3 will
Output as t3</p>

<pre><code>t3-[mango, apple, , {apple,top}]
</code></pre>

<p><a href="https://i.stack.imgur.com/9Cwls.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9Cwls.png" alt="enter image description here"></a></p>