I need to replace the values of a column in a mysql-db.

There is a column with values like that:

Flowers 505
Flowers 301
Flowers 440
.....

I want to remove "Flowers ", so that only the numbers remain.

Is there a way to make it with one command?

Michael

--
Michael Skaide

http://www.cycle24.de

UPDATE Table SET Column = REPLACE(Column, 'Flowers ', '');