title: SQLite SELECT LIKE query with forward slash
body: <p>In my database I'm storing timestamps in a TIMESTAMP field, the table structure is: (It would be difficult to change it to an int storing something like a unix epoch instead at this point)</p>
  
  <pre><code>CREATE TABLE timer (
      [id] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT,
      [topic] VARCHAR(60) NOT NULL,
      [desc] VARCHAR(500)  NULL,
      [project] INTEGER  NOT NULL,
      [start] TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
      [end] TIMESTAMP NULL,
      [user] INTEGER  NOT NULL
  )
  </code></pre>
  
  <p>Now I need to select rows where the start date is in a certain month. I thought I could just do something like:</p>
  
  <pre><code>SELECT * FROM timer WHERE start LIKE "%month/%/year%"
  </code></pre>
  
  <p>But it's not working. But if I just do something like:</p>
  
  <pre><code>SELECT * FROM timer WHERE start LIKE "%8%"
  </code></pre>
  
  <p>It runs and selects all the rows with a start date in August (as well as ones with 8 in the time hehe)</p>
  
  <p>I tried narrowing the issue down to:</p>
  
  <pre><code>SELECT * FROM timer WHERE start LIKE "%/%"
  </code></pre>
  
  <p>And found that the query returns absolutely nothing if the like string contains a forward slash <code>/</code>. I tried escaping the slash but that didn't change anything. </p>
  
  <p>Why is my query not working when I include forward slashes? </p>
  
  <p>Here is some sample data from the table:</p>
  
  <pre><code>id  topic     desc        project  start                   end                     user
  1    Topic 1   A Desc.     1        8/12/2016 11:34:09 PM   8/12/2016 11:34:15 PM   1
  2    Topic 2   A 2ndDesc.  1        8/13/2016 12:55:44 AM   8/13/2016 12:55:49 AM   1
  </code></pre>
  
  <p>EDIT:</p>
  
  <p>As requested, here is an INSERT:</p>
  
  <pre><code>INSERT INTO timer (`topic`, `project`, `desc`, `start`, `end`, `user`) VALUES ('My Topic', '1', 'This is a Desc', '2016-08-15 10:03:41', '2016-08-16 12:03:41', '1')
  </code></pre>