把创建时间格式化为年月日时分秒 然后用week函数格式化
select WEEK(FROM_UNIXTIME(t.`create_time`/1000, '%Y-%c-%d %h:%i:%s'),1)
eg:
一周内点赞数评论数总和排序sql:
SELECT t.* FROM
t_find t
order by WEEK(
FROM_UNIXTIME(t.`create_time`/1000, '%Y-%c-%d %h:%i:%s'),1) desc,
(t.comment_count +t.find_like_count) desc LIMIT 20