我的mySQL查询有问题。
我的桌子:
-------------------------------------------------------
| id | user_id | name | assigned_at | unassigned_at |
-------------------------------------------------------
| 1 | 20 | TEST | 2018-12-12 | null |
| 2 | 20 | TEST 2 | 2018-12-01 | 2018-12-12 |
| 3 | 20 | TEST 3 | 2018-11-20 | 2018-12-01 |
-------------------------------------------------------
如何按日期获取记录?例如,我想获得记录编号2
但我需要使用user_id where_in('20', '30', '33', '20')
您可以在WHERE语句中添加按日期列筛选
SELECT *
FROM <your table>
WHERE assigned_at = '2018-12-01'
AND user_id IN ('20', '30', '33')