title: C# SQLite Parameterized Select Using LIKE
body: <p>I am trying to do an SQL query such as </p>
  
  <pre><code>SELECT * FROM [TABLE] WHERE hostname LIKE '%myhostname%';
  </code></pre>
  
  <p>This works fine in plain SQL, but when I use System.Data.SQLite in C#, it only works with a literal, not a parameter, such as </p>
  
  <pre><code>string sel = "SELECT * FROM [TABLE] WHERE hostname LIKE '%@host%'";
  ...
  command.Parameters.AddWithValue("@host", "myhostname");
  </code></pre>
  
  <p>This returns no results.</p>