title: How to compare time in mysql
body: <p>I have a column of <strong>Time</strong> data type in mysql. I want to compare the time with a time string but don't know how to compare it. e.g., I want to know that some specific <strong><em>time is greater than 10:30:00</em></strong>. How can I check it? I have this query but it is not showing any result although the data is available. what I am doing wrong?</p>
  
  <pre><code>select PK, userID, lr.Date, lr.Time, Half, lr.InOut, Op_UserID, About
  from loginrecord lr
  where lr.Date Between '2017-05-17' AND '2017-05-17'
  and lr.InOut = 1
  and lr.Time &gt; '10:30:00'
  </code></pre>