title: sql select query excluding certain values
body: <p>The requirement is to exclude ItemA and ItemE from the search as they contain value 1 in columnB.</p>
  
  <p><img src="https://i.stack.imgur.com/q3Ooa.jpg" alt="enter image description here"></p>
  
  <p>The final result should be something like this </p>
  
  <p><img src="https://i.stack.imgur.com/79qRF.jpg" alt="enter image description here"></p>
  
  <p>I have tried <code>SELECT * FROM my_table WHERE ColumnB not like '1'</code> , but this just removes the rows having 1 , I want the whole ITEM A/ITEM E removed as the contain value 1.</p>