title: Using SQLDF to select specific values from a column
body: <p>SQLDF newbie here.</p>
  
  <p>I have a data frame which has about 15,000 rows and 1 column.
  The data looks like:</p>
  
  <pre><code>cars
  autocar
  carsinfo
  whatisthat
  donnadrive
  car
  telephone
  ...
  </code></pre>
  
  <p>I wanted to use the package sqldf to loop through the column and
  pick all values which contain "car" anywhere in their value. 
  However, the following code generates an error.</p>
  
  <pre><code>&gt; sqldf("SELECT Keyword FROM dat WHERE Keyword="car")
  Error: unexpected symbol in "sqldf("SELECT Keyword FROM dat WHERE Keyword="car"
  </code></pre>
  
  <p>There is no unexpected symbol, so I'm not sure whats wrong.</p>
  
  <p>so first, I want to know all the values which contain 'car'.
  then I want to know only those values which contain just 'car' by itself.</p>
  
  <p>Can anyone help.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>allright, there was an unexpected symbol, but it only gives me just car and not every
  row which contains 'car'.</p>
  
  <pre><code>&gt; sqldf("SELECT Keyword FROM dat WHERE Keyword='car'")
    Keyword
  1     car
  </code></pre>