title: MySql Query rows that same values in 2 columns
body: <p>I have a table (MyTable) with this;</p>
  
  <pre><code> id   date        value1   value2
      1    2016-09-16    1       null
      2    2016-09-16    null    null
      3    2016-09-16    3       null
      4    2017-01-16    2       null
      5    2017-01-16    null     1
      6    2017-01-16    null     34
      7    2017-01-16    null      3
  </code></pre>
  
  <p>Needing it to return rows that have matching values in value1 and value2
  In above I need rows 1, 3, 5, 7 returned.</p>
  
  <p>If possible sorted by date, value2</p>