Date Comparison in MySQL Columns

[Aravind Prasad]

Dear Ranchers,
I'm doing JSP and MySQL in my project and and i've a doubt in the query.
The table details are given below

table name : test
----------------------------------
id   | date_in     | actual_date |
----------------------------------
001  | 01-01-2006  | 01-01-2006  |
002  | 02-01-2006  | 02-01-2006  |
003  | 03-01-2006  | 01-01-2006  |
004  | 04-01-2006  | 07-01-2006  |
005  | 05-01-2006  | 07-01-2006  |
006  | 06-01-2006  | 07-01-2006  |
007  | 07-01-2006  | 07-01-2006  |
008  | 08-01-2006  | 01-01-2006  |
009  | 09-01-2006  | 09-01-2006  |
----------------------------------

I want to write a query to compare the 2 colums , date_in and actual_date and for example

Select * from test where date_in > actual_date
So that it can bring some results which are early delivery's

Please help me ranchers for my query.

Thanks in advance..

regards
Aravind Prasad

[Jan Cumps]

Select * from test where date_in > actual_date

This query looks fine to me.
If date_in is the expected date, and actual_date is the delivery date, then this query will return early deliveries.
(at least, when these columns are defined as date fields in MySQL).

Regards, Jan