Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @today := CURDATE();
- SET @yesterday := DATE_SUB(@today, INTERVAL 1 DAY);
- SELECT DATE_PUBLISH,
- CONCAT(@today, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s')) AS dp1,
- CONCAT(@yesterday, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s')) AS dp2
- FROM b_blog_post
- WHERE PUBLISH_STATUS='P'
- ORDER BY RAND()
- LIMIT 20;
- UPDATE b_blog_post
- SET DATE_PUBLISH = CONCAT(@today, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s'))
- WHERE PUBLISH_STATUS='P'
- ORDER BY RAND()
- LIMIT 20;
- UPDATE b_blog_post
- SET DATE_PUBLISH = CONCAT(@yesterday, ' ', DATE_FORMAT(DATE_PUBLISH, '%H:%i:%s'))
- WHERE PUBLISH_STATUS='P'
- ORDER BY RAND()
- LIMIT 20;
Add Comment
Please, Sign In to add comment