A
A
Aldevex2018-02-25 00:02:21
MySQL
Aldevex, 2018-02-25 00:02:21

How to find the same values ​​in a span of time?

Hello.
There are records of type
id | text | date
0 | OnFl | 2018-02-24 21:42:00
1 | OnFl | 2018-02-24 21:45:17
2 | OnFl | 2018-02-24 21:48:11
3 | Onssfl | 2018-02-24 21:48:11
How to find the same records in a time interval of 10 minutes for certain fields? Not knowing how much (datetime) to how much to count, maybe the time period can be any
If the same 'text' for 10 minutes 'date' (records with id 0 , 1 ,2)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Mikhail Bobkov, 2018-02-25
@mike_bma

By interval - take the date, add the required interval to it and make a request with these dates.
Get the data and check the identity of the required fields.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question