title: dplyr filter() with SQL-like %wildcard%
body: <p>Suppose I have the following data:</p>
  
  <pre><code>foo &lt;- data.frame(Company = c("company1", "foo", "test", "food"), Metric = rnorm(4, 10))
  
  &gt; foo
     Company    Metric
  1 company1 10.539970
  2      foo  9.487823
  3     test  9.663994
  4     food  9.499327
  </code></pre>
  
  <p>Why does the following code return 0 results (instead of the second and fourth rows)?</p>
  
  <pre><code>library(dplyr)
  library(data.table)
  
  foo %&gt;% dplyr::filter(Company %like% "%foo%")
  </code></pre>
  
  <p>I'm trying to use the SQL-equivalent wildcard filter on a particular input string to <code>dplyr::filter</code>, using the <code>%like%</code> operator from the <code>data.table</code> package.</p>
  
  <p>What am I doing wrong?</p>