请教一个数据查询问题

ryljun

下面的查询可以正常返回，那么如果查询条件是IN_DATE字段在两个日期之间，应该怎么写？

1. $row = TD::DB()->select(
   
2.                       TD::tableFix("ml_dor_in"),                   //表名
   
3.                       ["DORMITORIES_ID","IN_DATE","WHY_IN","EMPLOYEE_ID","IN_OUT"],                   //要查询的字段
   
4.                       ["DORMITORIES_ID" => $DORMITORIES_ID,  //查询条件
   
5.                   ]);

复制代码

建飞

顶一下 碰到了类似的问题

通达_鲁国胜

1. // [><] and [<>] is also available for datetime
   
2. $database->select("account", "user_name", [
   
3.         "birthday[<>]" => [date("Y-m-d", mktime(0, 0, 0, 1, 1, 2015)), date("Y-m-d")]
   
4. ]);
   
5. // WHERE ("birthday" BETWEEN '2015-01-01' AND '2017-01-01')
   
6. 
   
7. $database->select("account", "user_name", [
   
8.         "birthday[><]" => [date("Y-m-d", mktime(0, 0, 0, 1, 1, 2015)), date("Y-m-d")]
   
9. ]);
   
10. // WHERE ("birthday" NOT BETWEEN '2015-01-01' AND '2017-01-01')
    

复制代码

您说的应该是这种情况。

另外还有一些其他的查询供您参考：

1. $database->select("account", "user_name", [
   
2.         "email" => "foo@bar.com"
   
3. ]);
   
4. // WHERE email = 'foo@bar.com'
   
5. 
   
6. $database->select("account", "user_name", [
   
7.         "user_id" => 200
   
8. ]);
   
9. // WHERE user_id = 200
   
10. 
    
11. $database->select("account", "user_name", [
    
12.         "user_id[>]" => 200
    
13. ]);
    
14. // WHERE user_id > 200
    
15. 
    
16. $database->select("account", "user_name", [
    
17.         "user_id[>=]" => 200
    
18. ]);
    
19. // WHERE user_id >= 200
    
20. 
    
21. $database->select("account", "user_name", [
    
22.         "user_id[!]" => 200
    
23. ]);
    
24. // WHERE user_id != 200
    
25. 
    
26. $database->select("account", "user_name", [
    
27.         "age[<>]" => [200, 500]
    
28. ]);
    
29. // WHERE age BETWEEN 200 AND 500
    
30. 
    
31. $database->select("account", "user_name", [
    
32.         "age[><]" => [200, 500]
    
33. ]);
    
34. // WHERE age NOT BETWEEN 200 AND 500
    
35. 
    
36. // [><] and [<>] is also available for datetime
    
37. $database->select("account", "user_name", [
    
38.         "birthday[<>]" => [date("Y-m-d", mktime(0, 0, 0, 1, 1, 2015)), date("Y-m-d")]
    
39. ]);
    
40. // WHERE ("birthday" BETWEEN '2015-01-01' AND '2017-01-01')
    
41. 
    
42. $database->select("account", "user_name", [
    
43.         "birthday[><]" => [date("Y-m-d", mktime(0, 0, 0, 1, 1, 2015)), date("Y-m-d")]
    
44. ]);
    
45. // WHERE ("birthday" NOT BETWEEN '2015-01-01' AND '2017-01-01')
    
46. 
    
47. // You can use not only single string or number value, but also array
    
48. $database->select("account", "user_name", [
    
49.         "OR" => [
    
50.                 "user_id" => [2, 123, 234, 54],
    
51.                 "email" => ["foo@bar.com", "cat@dog.com", "admin@medoo.in"]
    
52.         ]
    
53. ]);
    
54. // WHERE
    
55. // user_id IN (2,123,234,54) OR
    
56. // email IN ('foo@bar.com','cat@dog.com','admin@medoo.in')
    
57. 
    
58. // [Negative condition]
    
59. $database->select("account", "user_name", [
    
60.         "AND" => [
    
61.                 "user_name[!]" => "foo",
    
62.                 "user_id[!]" => 1024,
    
63.                 "email[!]" => ["foo@bar.com", "cat@dog.com", "admin@medoo.in"],
    
64.                 "city[!]" => null,
    
65.                 "promoted[!]" => true
    
66.         ]
    
67. ]);
    
68. // WHERE
    
69. // `user_name` != 'foo' AND
    
70. // `user_id` != 1024 AND
    
71. // `email` NOT IN ('foo@bar.com','cat@dog.com','admin@medoo.in') AND
    
72. // `city` IS NOT NULL
    
73. // `promoted` != 1
    
74. 
    
75. // Or fetched from select() or get() function
    
76. $database->select("account", "user_name", [
    
77.         "user_id" => $database->select("post", "user_id", ["comments[>]" => 40])
    
78. ]);
    
79. // WHERE user_id IN (2, 51, 321, 3431)
    

复制代码