Replace / with - in multiple mysql rows...

Replace / Modify / Update?

[smxmedia]

Hi everyone.

I have a mysql database with about 2500 stock items in. The problem I have is that the addition dates are a little screwed up. The dates should have hyphens not forward slashes in the database. As you can imagine changing 1500+ rows manually would take a very long time.

The dates are like this.

e.g.

Wrong = 10/10/1000
Right = 10-10-1000

Is there an easy way to change all the slashes in the table to hyphens?

Thanks in advance.

[jatar_k]

Welcome to WebmasterWorld smxmedia,

it would be easy enough to write a script that will select the date, replace the / with - and then update based on row id.

there may be a mysql function that could do it but I don't know off the top of my head.

[freeflight2]

[dev.mysql.com...]
UPDATE table SET row=REPLACE(row, '/', '-');

[smxmedia]

Thanks freeflight ill have a play with it.