title: How to select R data.table rows based on substring match (a la SQL like)
body: <p>I have a data.table with a character column, and want to select only those rows that contain a substring in it.  Equivalent to SQL <code>WHERE x LIKE '%substring%'</code></p>
  
  <p>E.g.</p>
  
  <pre><code>&gt; Months = data.table(Name = month.name, Number = 1:12)
  &gt; Months["mb" %in% Name]
  Empty data.table (0 rows) of 2 cols: Name,Number
  </code></pre>
  
  <p>How would I select only the rows where Name contains "mb"?</p>