查询某X的数据
# 查询某天的数据
查询今天to_days(now())
EXPLAIN SELECT
*
FROM
member_schedule_relation msr
LEFT JOIN `schedule` s ON s.id = msr.schedule_id
LEFT JOIN member m ON m.id = msr.member_id
WHERE
msr.member_id = 1
AND s.deleted = 0
AND s.start_time <= '2020-4-3' AND s.end_time >= '2020-4-2'
ORDER BY
s.start_time
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
SELECT
*
FROM
article
WHERE
to_days( create_time ) = to_days( '2018-09-10' )
1
2
3
4
5
6
2
3
4
5
6
# 查询某天到某天的数据
SELECT
*
FROM
article
WHERE
create_time BETWEEN '2019-4-1'
AND '2019-4-7'
1
2
3
4
5
6
7
2
3
4
5
6
7
# 查询某个月的数据
SELECT
*
FROM
article
WHERE
date_format( create_time, '%Y-%m' ) = '2019-04'
1
2
3
4
5
6
2
3
4
5
6
# 查询某年的数据
SELECT
*
FROM
article
WHERE
date_format( create_time, '%Y' ) = '2018'
1
2
3
4
5
6
2
3
4
5
6
Last Updated: 2023/02/16, 14:02:00