title: LIKE operator not working properly with date
body: <p>I'm trying to return a record which contains the year of a date, let me explain better, this is my query:</p>
  
  <pre><code>$query = "SELECT coach.*
    FROM coach_career coach_cr
    LEFT JOIN coach coach ON coach.id = coach_cr.coach_id
    LEFT JOIN competition_seasons s ON s.id = :season_id
    WHERE coach_cr.team_id = 95 AND `start` LIKE '%2017/2018%'";
  </code></pre>
  
  <p>I need to select all the <code>coach</code> fields on <code>coach_career</code>, a <code>coach</code> can train different team in different <code>seasons</code>, so I need to take the coach that have as <code>season.name</code> the value <code>2017/2018</code>, but the <code>start</code> date have a datetime format like: 2017-01-01</p>
  
  <p>How can I handle this situation?</p>
  
  <p><strong>Sample Data</strong></p>
  
  <p>coach:</p>
  
  <pre><code>id | name | last_name
   1   foo      test
  </code></pre>
  
  <p>coach_career:</p>
  
  <pre><code>coach_id | team_id | start       | end
     1         95       2017-01-01   NULL
  </code></pre>
  
  <p>competition_seasons</p>
  
  <pre><code>id | name | 
  1    2017/2018
  </code></pre>