Textpattern CMS

#1 2005-10-17 11:40:41

gerhard

Plugin Author

From: London, UK

Registered: 2005-06-29

Posts: 409

Website

db-wide operations

I keep finding myself editing tens of db entries for unwanted chars such as “,” etc.

Which would be the best approach for having unwanted chars removed/replaced from specific columns in MySQL?

Thanks, Gerhard.

Last edited by gerhard (2005-10-17 11:41:14)

---

Twitter | Github

#2 2005-10-17 11:58:30

gerhard

Plugin Author

From: London, UK

Registered: 2005-06-29

Posts: 409

Website

Re: db-wide operations

Answer found: update textpattern set custom_1 = replace(custom_1,”,”,”“);

---

Twitter | Github