title: Wild card in REGEXP?
body: <p>I have data like this in a longtext column:</p>
  
  <pre><code>Name: Adam Smith
  Name: Bob Johnson
  Name: John Hansen
  </code></pre>
  
  <p>Is it possible to use a wildcard, within regexp? Say a user searches <code>Smith</code>, in pseudo-code:</p>
  
  <pre><code>SELECT * FROM mytable
  WHERE `file` REGEXP 'Name: %Smith%\n'
  </code></pre>
  
  <p>I'm pretty sure the <code>%</code> wildcard isn't a function within regexp. Is it possible to do this?</p>