PHP - 从数据库geting first record和其他3分钟值中选择数据

Question

I just wanna know how to select data from specific user in database but just print data in a interval of 3 minutes.

For example: THIS IS DATABSE:

ID ------ User----- Hour----- Minute
#1 ------ USERA---- 09 ------ 00
#2 ------ USERA---- 09 ------ 01
#3 ------ USERA---- 09 ------ 02
#4 ------ USERA---- 09 ------ 03
#5 ------ USERA---- 09 ------ 04
#6 ------ USERA---- 09 ------ 05
#7 ------ USERA---- 09 ------ 06
#8 ------ USERA---- 09 ------ 07
#9 ------ USERA---- 09 ------ 08
#10 ------ USERA---- 09 ------ 09
#11 ------ USERA---- 09 ------ 10

THIS IS WHAT I WANNA SHOW

#1 ------ USERA---- 09 ------ 00
#4 ------ USERA---- 09 ------ 03
#7 ------ USERA---- 09 ------ 06
#10 ------ USERA---- 09 ------ 09
...

Is there a way to do this?

Thanks

Answer 1

A quick solution may be to use the modula function..

SELECT * FROM table WHERE (table.Minute % 3) = 0

If you want to start from the first instance of hour,minute and then get 3minutes from that, you may use this query:

SELECT * FROM table WHERE ((table.Minute - (SELECT Minute FROM table ORDER BY table.Minute,table.Hour ASC LIMIT 1)) % 3 ) = 0;

Working demo can be found here: https://paiza.io/projects/4tlF_ZtwTSmSHFY_YKhtaw?language=mysql

Edit:
You may get better results by using GROUP BY

SELECT * FROM table WHERE ((table.Minute - (SELECT table.Minute FROM table GROUP BY table.Minute,table.Hour ORDER BY table.Hour ASC LIMIT 1)) % 3 ) = 0;