title: SQL search query using LIKE and WHERE
body: <p>I need your help. </p>
  
  <p>This is my Products Table:</p>
  
  <pre><code> id       name       type
   1        item 1     A
   2        item 2     A
   3        item 3     B
   4        item 4     B
  </code></pre>
  
  <p>etc...</p>
  
  <p>I want to search all possible records which start with item in <strong>Type A</strong> </p>
  
  <p>I have this query: </p>
  
  <pre><code> SELECT * FROM products 
   WHERE type = 'A'
   OR name LIKE '%item%';   
  </code></pre>
  
  <p>But I'm getting possible records from other types. How can I filter to only display Type A? Any ideas? </p>