Get TableA id where TableB id is equal to TableA column which has a string
<p>I have two tables TableA and TableB.</p>

<p>TableA:</p>

<pre><code>id | users        |
-------------------
1  | ["2","5","4"]|
2  | NULL         |
3  | ["5"]        |
</code></pre>

<p>TableB</p>

<pre><code>id | Name |
-----------
2  | Jane |
3  | Joe  |
4  | John |
5  | Jack |
</code></pre>

<p>How can I get a result to show the TableA id where TableB id is in TableA Users?</p>

<ul>
<li>So for Jane = 1</li>
<li>for Joe = Null</li>
<li>for John = 1</li>
<li>and Jack = 1,3</li>
</ul>