By Robardi56 on

Hi,
I have 300 entries in my database. each entry has a custom cck field with same data in each field. It's a simple text field.

I made a typo and need to correct all those. Is there an automatic way to do so ? A module ?

Thanks,
Brakkar

⋅ Categories: Drupal 6.x

Comments

Eugene Dubois’s picture

Eugene Dubois commented

an sql-command, directly on the database is the only option I can think of...

Robardi56’s picture

Robardi56 commented

ok, the only problem with this is that the text index of drupal won't be updated ? Are there any other issue ?

Thanks,
Brakkar

Jeff Burnz’s picture

Jeff Burnz commented

SQL UPDATE

http://www.techonthenet.com/sql/update.php
http://en.wikipedia.org/wiki/Update_(SQL)

Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
amariotti’s picture

amariotti commented

Another alternative would be to use the Editview module.

http://drupal.org/project/editview

I'm not as savvy with SQL UPDATE so that was the alternative that I went with.