Guest User

Untitled

a guest
Jan 21st, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. SET @today := CURDATE();
  2. SET @yesterday := DATE_SUB(@today, INTERVAL 1 DAY);
  3.  
  4. SELECT DATE_PUBLISH,
  5. CONCAT(@today, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s')) AS dp1,
  6. CONCAT(@yesterday, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s')) AS dp2
  7. FROM b_blog_post
  8. WHERE PUBLISH_STATUS='P'
  9. ORDER BY RAND()
  10. LIMIT 20;
  11.  
  12. UPDATE b_blog_post
  13. SET DATE_PUBLISH = CONCAT(@today, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s'))
  14. WHERE PUBLISH_STATUS='P'
  15. ORDER BY RAND()
  16. LIMIT 20;
  17.  
  18. UPDATE b_blog_post
  19. SET DATE_PUBLISH = CONCAT(@yesterday, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s'))
  20. WHERE PUBLISH_STATUS='P'
  21. ORDER BY RAND()
  22. LIMIT 20;
Add Comment
Please, Sign In to add comment