How can I calculating between 2 date fields.

[23457078]

mysql> select * from seizoen;
+----------+------------+------------+-----------+
| seizoen | begin | end | categorie |
+----------+------------+------------+-----------+
| 20032004 | 1995-06-01 | 1997-06-01 | F |
| 20032004 | 1997-06-01 | 1999-06-01 | E |
+----------+------------+------------+-----------+
2 rows in set (0.00 sec)

I was borne at 1995-01-27 and when i select * whats my
categorie F or E.

 

[r937]

neither

rudy

http://r937.com/

SQL Consulting

 

[23457078]

sorry,


I ment the date is '1995-08-01' and how can i get the right
categorie. Something like
'select categorie from seizoen where '1995-08-01' between
begin and end;'

 

[r937]

something like? exactly like

select categorie 
  from seizoen 
 where '1995-08-01' between begin and end

rudy

http://r937.com/

SQL Consulting