Advertisement
Guest User

Untitled

a guest
Sep 29th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.16 KB | None | 0 0
  1. SELECT name as game,
  2. DATE_FORMAT(`start`,'%Y-%m-%d') as `start`
  3. FROM games
  4. WHERE EXTRACT(YEAR from `start`) IN (2011,2012)
  5. ORDER BY `start` ASC,name ASC
  6. LIMIT 50;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement