title: Updating column value based on if the value is a substring of another column
body: <p>Suppose I have two tables in the database:</p>
  <p><strong>Table_1</strong></p>
  <pre><code>Column_1  |  Column_2    | Column_3
  
  1            End Table     NULL
  2            BENQ Monitor  NULL
  3            Tao Lamp      NULL
  </code></pre>
  <p><strong>Table_2</strong></p>
  <pre><code>Column_1 | Column_2
  
  Table      Wooden Table 
  Monitor    Computer Monitor          
  Lamp       LED Lamp
  </code></pre>
  <p>And I want to update <strong>Column_3</strong> in <strong>Table_1</strong> as follows by checking if <strong>Column_2</strong> in <strong>Table_1</strong> contains the substring given in <strong>Column_1</strong>, <strong>Table_2</strong>.</p>
  <pre><code>Column_1  |  Column_2    | Column_3
  
  1            End Table     Wooden Table
  2            BENQ Monitor  Computer Monitor
  3            Tao Lamp      LED Lamp
  </code></pre>
  <p>How would I go about doing this? I have tried the below but it's giving me an &quot;invalid identifier&quot; error.</p>
  <pre><code>UPDATE Table_1
  SET Table_1.Column_3 = Table_2.Column_2
  WHERE Table_1.Column_2 LIKE '%' + Table_2.Column_1 + '%';
  </code></pre>
  <p>Appreciate any assistance.</p>