What's wrong with this MySQL SELECT statement?

[BigToque]

I have a table called "schedule" and that table has a field called "year". "year" is a float value.

All records contain one of these entries:

2004.11
2004.12
2004.13
2004.21
2004.22
2004.23
2004.31
2004.32
2004.33

This is my statement:

SELECT * FROM `schedule` WHERE year = 2004.32

The query runs and is supposed to select all records from the 2004.32 season, but it doesn't select any data.

[hemebond]

Change the column from FLOAT to DECIMAL. Direct comparisons seem to work in them.DECIMAL(4,2)

[Horus Kol]

just out of interest - for storing date information, why not use a timestamp?

[rayd]

Seems like perhaps you need to store date of the year instead of month and date? If so, a timestamp might still be better, like what Horus said, then you can use : mysql> SELECT DAYOFYEAR('1998-02-03');
-> 34
I am jumping to conclusions, I know. :D

[BigToque]

Thanks for the help guys, I was able to figure it out.

The way my numbering system worked was like this:

year.xy

year = year
x= spring league(1), summer league(2), winter league(3)
y= preseason(1), regular season(2), playoffs(3)

basically, I just ended up making 3 integer fields as opposed to 1 float and now everything works like I want.

[rayd]

Glad to hear, the new schema is SO much better, having 3 fields makes a world of sense. :thumbsup: