I have a table in which each entry has a view counter. I would like to create a list that displays only entries that are within 100 views of a 1,000 view threshold. But, I want to also show each entry at any interval of 1,000 views. I.E., I would want to show all the following entries:
I am not quite sure the best way to do this, or if it is possible, in a MYSQL query.
I was thinking something along the lines of dividing each view count by 1000, and if the result is between x.95 - x.05 showing the row.
Any help on how to implement this, or a better solution, would be appreciated.