title: Update column with value from another table
body: <p>I have two tables:
  Table1</p>
  <pre><code>id name node
  ============
  1 John 2277415921,2277415917,2277415929,2277415937
  2 Jane 1098140458,1098146293,1098145477,1098140669
  </code></pre>
  <p>and Table2</p>
  <pre><code>id nodeid      name
  ==================
  1  2277415937  Kirk
  2  1098140669  Serena
  </code></pre>
  <p>I need to <code>UPDATE</code> the <code>name</code> column in <code>table1</code> from <code>table2</code> when the value from the <code>nodeid</code> column in <code>table2</code> is in the <code>node</code> column in <code>table1</code></p>
  <p>I try it this way, but it doesn't work</p>
  <pre><code>UPDATE table1 t1
  INNER JOIN table2 t2 ON t1.node LIKE '%'+t2.nodeid+'%'
  SET t1.name = t2.name
  </code></pre>
  <p>Can you please tell me how to do that? Thanks</p>