+--------------+---------------+
| Value | Username |
+--------------+---------------+
| 31 August 2007 | mobile |
| 22 June 2008 | bbcnet |
| 21 August 2007 | balku |
| 21 August 2007 | rkmar |
| 21 August 2007 | sans |
| 1 June 2008 | kame |
| 20 July 2008 | yogh |
--------------------------- -----

Above is my mysql table structure, What I want to do is extract the username from the above list which will reach the above mentioned date in 5days.
For example today is 15 August 2007, I want to get username whose date is going to reach 21 august 2007 after 6 days.
Lets say after following will be user whose date will be 21 August 2007 after 6 days.

| 21 August 2007 | balku |
| 21 August 2007 | rkmar |
| 21 August 2007 | sans |

Check the mysql manual for date and time functions; I use the manual for version 3.23, 4.0 and 4.1 and in there it's chapter 12.5
You will probably end with something like
Hope you were clever enough to make the value column a date type, else it might not work.