Код: Выделить всё
# mysql -ppass -e "use db; \
> SELECT * FROM table \
> WHERE user_id = '2' AND direction = 'in' \
> AND TIME(date) BETWEEN '08:30' AND '09:45' LIMIT 0, 10;"
+------+---------------------+-----------+---------+
| id | date | direction | user_id |
+------+---------------------+-----------+---------+
| 65 | 2014-04-02 09:18:01 | In | 2 |
| 70 | 2014-04-02 09:44:02 | In | 2 |
| 1109 | 2014-04-14 09:27:10 | In | 2 |
| 1355 | 2014-04-16 09:29:27 | In | 2 |
| 2648 | 2014-05-06 09:19:37 | In | 2 |
| 2770 | 2014-05-07 09:11:38 | In | 2 |
| 2864 | 2014-05-08 08:47:54 | In | 2 |
| 2869 | 2014-05-08 08:59:32 | In | 2 |
| 2976 | 2014-05-12 09:14:22 | In | 2 |
| 2985 | 2014-05-12 09:37:27 | In | 2 |
+------+---------------------+-----------+---------+
Хочется получить только первую строку с датой:
Код: Выделить всё
| 65 | 2014-04-02 09:18:01 | In | 2 |
| 1109 | 2014-04-14 09:27:10 | In | 2 |
| 1355 | 2014-04-16 09:29:27 | In | 2 |
| 2648 | 2014-05-06 09:19:37 | In | 2 |
| 2770 | 2014-05-07 09:11:38 | In | 2 |
| 2864 | 2014-05-08 08:47:54 | In | 2 |
| 2976 | 2014-05-12 09:14:22 | In | 2 |
может быть можно и в запросе это сделать, но я не нашел.