如何在mysql中过滤两次的记录 - How can filter the record with two time in mysql?

How can filter the record with two time in mysql?

本文关键字：两次记录 mysql 过滤 | 更新日期: 2023-10-25

我有一个带有时间字段的表，我有两个参数time。选择记录，而不是之间的时间

前

 p1 = 14:00:00 , p1 = 21:00:00

样品表为

 ------------------------
| id | time     | status|
 ------------------------
| 1  | 12:00:00 | 1     |
 ------------------------
| 2  | 10:56:00 | 1     |
 ------------------------
| 3  | 09:00:00 | 1     |
 ------------------------
| 4  | 16:00:00 | 1     |
 ------------------------
| 5  | 02:00:00 | 1     |
 ------------------------
| 6  | 20:00:00 | 1     |
 ------------------------

我需要选择那个记录，除了那些id 4,6

输出类似

------------------------
| id | time     | status|
 ------------------------
| 1  | 12:00:00 | 1     |
 ------------------------
| 2  | 10:56:00 | 1     |
 ------------------------
| 3  | 09:00:00 | 1     |
 ------------------------
| 5  | 02:00:00 | 1     |
 ------------------------

如何制作这个的mysql

试试这个

SELECT * FROM YOUR_TABLE WHERE time NOT BETWEEN '14:00:00' AND '21:00:00'