search

interconnectit / Search-Replace-DB

This script was made to aid the process of migrating PHP and MySQL based websites. Works with most common CMSes.
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
GNU General Public License v3.0
3.99k stars 850 forks source link

Make selected tables filterable #374

Open Zodiac1978 opened 2 years ago

Zodiac1978 commented 2 years ago

I have a huge Multisite with 160+ sites and sometimes things happen (like GDPR changes) and we need to adjust some text. We couldn't centralize this, because every site has different needs.

So I would like to use this tool. With so many tables the search & replace duration is long. Very long.

I can just include columns like post_content and I can use selected tables, but I still need to click every single table. With 160+ sites this is not very easy. Why not adding a filter feature, to choose every table containing a chosen string, so I can filter the list for "_posts" for example. This would speed up the search & replace.

Zodiac1978 commented 2 years ago

At the moment I found a workaround with jQuery and some selector magic, like this to just show the options (as example) table (through the browser console): jQuery( "option:not([value$='_options'])" ).remove();