How to divide records with a number?

[Anon]

Hello,
I would like to divide all records of a field with 340,750.
The field is called "price" and there are about 200 values in it.

Any ideas how this can be done?

[Anon]

SELECT field / 340,750 FROM table;

Sounds strange to me, so maybe I didn't understand the question correctly?

F.

[Anon]

Hello,

This is what i did :

alter table test change price price float(10,3);

update test set price=price/340.75;

Now everything is ok.

Thomas