I've searched high and long for an answer to this.
I have a database that collects data whenever a user logs onto our network.
Some users are complaining of disconnections, so I would like to crawl the database, and find any sections where a user is appearing in the database on 3 sequential rows.

Database Structure is:

```
ID          USER

1           MIKE
2           JOHN
3           MIKE
4           MIKE
5           MIKE
6           JOHN
7           JOHN
8           MIKE

```

I would like the query to return the below (Mike user logged on with 3 sequential ID's)

```
ID          USER

3           MIKE
4           MIKE
5           MIKE

```

I'm stumped as to how to even attack this.

I'm thinking something like:

```
SELECT * FROM `user_log` WHERE `id` IS sequential??? and `username` == ???

```

Possibly a sub-select ?