title: Filtering out IDs that contain a certain value in another column
body: <p>So I am trying to filter out IDs from these 2 tables I 'union all'ed. Basically if the ID contains a certain name, I want to filter them out of the query. Here is an example</p>
  
  <pre><code>ID,Name
  
  1,Mark  
  1,John  
  2,Peter  
  2,Matt  
  3,Henry  
  3,Matt  
  4,John  
  4,Olaf
  </code></pre>
  
  <p>So I do not want to include IDs that contain 'Matt' meaning I would like to filter out IDs 2 and 3 out completely.</p>
  
  <p>using something like:</p>
  
  <pre><code>select *  
  from name.table  
  where name not like 'Matt'  
  </code></pre>
  
  <p>only seems to filter out the row.</p>