title: Comparing TIMEDIFF in MySQL
body: <p>I have these following data:</p>
  
  <pre><code>ID   TIMEIN                 TIMEOUT
  1    2016-08-24 20:44:00    2016-10-22 19:35:36
  2    2016-08-24 20:58:00    2016-08-24 20:59:09
  </code></pre>
  
  <p>and the following query that I want to use to find all the entries where the timediff is lesser than 50 hours</p>
  
  <pre><code>SELECT TimeDiff(TimeOut,TimeIn) 
  from table where TimeDiff(TimeOut,TimeIn) &lt; '50:00:00' 
  </code></pre>
  
  <p>The second row should be returned because it's lesser than 50 hours, but the first row, which the timediff is more than 50 hours keep returning as well.</p>
  
  <pre><code>02:04:57
  15:10:49
  125:00:25
  </code></pre>
  
  <p>It returns all sort of value, including those larger than 50</p>
  
  <p>What query should I be using? Thank you</p>