Search and Replace

Hi,

thanks for your suggestion!

No, sorry, I don’t have plans for a feature like that at the moment, as it most likely would not be that useful for many users.
Also, there are several solutions available for that: You could either do a search/replace in the database (which is a little bit dangerous though), or export the table to file (I recommend CSV) and then do a search/replace in your text editor or even in Excel.
Then, just re-import the file and choose to replace the existing table.

Regards,
Tobias

Since common links span many of my tables, exporting CSVs would be even more time consuming that searching through WordPress site and editing tables manually.

How do I access the database?

Hi,

ok, then search/replacing in the database should be the best.
There are some plugins for this in the plugin directory which you could try (I don’t have names right now, sorry), or you could use a database administration tool like phpMyAdmin. That might even be installed on your server, otherwise you could ask your webhost company for it or just install it manually.

Regards,
Tobias

I do have access to the database that WordPress is using. Is TablePress data in that database? I didn’t see it when I was looking in there. Where would I find the TablePress data?

Hi,

yes, TablePress stores the table data in that database. You’ll find each table in the “wp_posts” table, with the “post_type” value being “tablepress_table” and the content of the post resemling a JSON encoded two-dimensional array of the table data.
That’s where you can do search and replace with SQL, but be careful to not break the format. Also note that characters like " or / need to be escaped with a \.

Regards,
Tobias