I have a log data in mysql
id | value | date
1 | 10.2 | 2017-07-20 18:00:00
2 | 10.5 | 2017-07-20 18:00:01
3 | 10.3 | 2017-07-20 18:00:03
then transformed it into hash dan sorted set in redis. This is my hashes:
hmset mylog:1 id 1 value 10.2 date 1388534400
hmset mylog:2 id 2 value 10.5 date 1388534401
hmset mylog:3 id 3 value 10.3 date 1388534402
and sorted set :
zadd log_date 1388534400 1
zadd log_date 1388534401 2
zadd log_date 1388534402 3
I want to perform query just like WHERE date beetween .... and ....
Is there any possible way to get data from hashes, based on date range in sorted set?
Thanks!