mySQL and subtracing .5

[Nigel]

I have a number in a INT field in a table and I want to subtract .5 (1/2)
from the number... ie 4-.5=3.5

I have tried it in mysql but it does seem to work, can anyone help with the
query

[Pedro Graca]

Nigel wrote:

I have a number in a INT field in a table and I want to subtract .5 (1/2)
from the number... ie 4-.5=3.5

I have tried it in mysql but it does seem to work, can anyone help with the
query

What query? ???

mysql> select id-0.5 from foobar where id<3;
+--------+
| id-0.5 |
+--------+
| 0.5 |
| 1.5 |
+--------+
2 rows in set (0.00 sec)
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Tony Marston]

Integers by their very definition are whole numbers, therefore decimal
places cannot be used. If you want decimal places then change the field type
to FLOAT, REAL, DECIMAL or NUMERIC.

--
Tony Marston

http://www.tonymarston.net

"Nigel" <no****@here.com> wrote in message
news:c1*******************@news.demon.co.uk...

I have a number in a INT field in a table and I want to subtract .5 (1/2)
from the number... ie 4-.5=3.5

I have tried it in mysql but it does seem to work, can anyone help with the query