Is there any way to do search and replace for content in a table? For example, say I have a column with a number of rows having the value of "Silver" and I want to change all of those rows to "Gold".
How would I go about doing that for hundreds of rows?
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
You would only be able to achieve this if the table is a server-side table (either Manual or a MySQL query-based table). In that case, you'd need to access your database, and run a query to find and replace data in a certain table/column. For example:
UPDATE `sometable` SET somecolumn=REPLACE(somecolumn,'this_part','that_part')
Hi,
Is there any way to do search and replace for content in a table? For example, say I have a column with a number of rows having the value of "Silver" and I want to change all of those rows to "Gold".
How would I go about doing that for hundreds of rows?
Thanks,
-Norm
Hello Norm
I am sorry to disappoint you, but unfortunately, something like this is not possible with the plugin's built-in features.
You would only be able to achieve this if the table is a server-side table (either Manual or a MySQL query-based table). In that case, you'd need to access your database, and run a query to find and replace data in a certain table/column. For example:
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables