title: "Where" statement : contains a certain substring
body: <p>I am using MySQL. </p>
  
  <p>I have a <strong>car</strong> table in my database, and there is a <code>name</code> column in that table.</p>
  
  <p>Suppose the <code>name</code> column of the table contain values:</p>
  
  <pre><code> +----------+
   |   name   |
   +----------+
   | AAA BB   |
    ----------
   | CC D BB  |
    ----------
   | OO kk BB |
    ----------
   | PP B CC  |
    ----------
  </code></pre>
  
  <p>I would like to search the table where <code>name</code> column value contains "<strong>BB</strong>" , What is the SQL command to achieve this ?</p>
  
  <p>I tried :</p>
  
  <pre><code>SELECT * FROM car WHERE name LIKE "BB";
  </code></pre>
  
  <p>But it does not work.</p>
  
  <p><strong>P.S.</strong></p>
  
  <p>The values in <code>name</code> column are random strings.</p>
  
  <p>Please do not ask me to use <strong>IN (...)</strong> , because the values in that column is unpredictable.</p>
  
  <p><strong>---------Please close this question--------------</strong></p>
  
  <p><strong>Sorry, I think I asked the question wrongly. Actually I am asking for a word match not a substring.</strong></p>