I need to retrieve data from MySQL from one day, but I don't know the interval between two rows (there may be 4 rows from one day and a gap of a week for example).

Let's say I have: *(following isn't code)*

```
3 rows where date = 2015-06-15
1 row where date = 2015-06-09
4 rows where date = 2015-06-05
```

I want to retrieve all 4 rows from 2015-06-05 with

```
[...] WHERE `date` < '2015-06-07'
```

or only one row from 2015-06-09 with

```
[...] WHERE `date` < '2015-06-14'
```

Is that possible with SQL only?