float comparison & MYSQL

[mikerh9]

Why when I do select from database and try to compare float field with float number, I have no results

amount --- type float

select from price where amount = 3.45 // doesn't work
select from price where amount = '3.45' //doesn't work

select * from price where amoun like '3.45' //work

My question is how to compare float field with float number. What operator I should use?

[lozza1978]

is this any help to you ?

http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html

[drew010]

see this page: http://dev.mysql.com/doc/refman/4.1/en/problems-with-float.html

if you change the field type to double, you will be able to use the = operator

edit: beaten

[mikerh9]

If I modify field type from float to double, will this change vvalue?

I don't want to see suddently that 55900,23 becomes 1212129999.

Thanks

drew010 wrote:

see this page: http://dev.mysql.com/doc/refman/4.1/en/problems-with-float.html

if you change the field type to double, you will be able to use the = operator

edit: beaten