Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 18th, 2012  |  syntax: None  |  size: 0.37 KB  |  hits: 6  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. MySQL: Why do these queries return different results?
  2. SELECT *
  3. FROM user_d1
  4. WHERE EXISTS (SELECT 1
  5.               FROM `user_d1`
  6.               WHERE birthdate BETWEEN '1989-08-04' AND '1991-08-04')
  7. ORDER BY timestamp_lastonline DESC
  8. LIMIT 20
  9.        
  10. SELECT *
  11. FROM user_d1
  12. WHERE birthdate BETWEEN '1989-08-04' AND '1991-08-04'
  13. ORDER BY timestamp_lastonline DESC
  14. LIMIT 20
create a new version of this paste RAW Paste Data