Usually I am using PhpMyAdmin for managing may MySQL databases, I think it is better to have "Find and Replace" for data of table's columns.
If we can select a column and the find particular
word/string and then replace with some other string through GUI, that will be very helpful.
But I was wandering , this feature is available or not. Did I miss something related to "find and replace feature" or please give your suggestion to this.
Best Regards,
Isuru Madhushankha
It's not available and I'm pretty sure that it's already in the feature requests. When implementing it, we would need a pretty good safeguard in terms of showing the number of replacements and getting a confirmation from the user, because it's so easy to make bad replacements.
Maybe also, show a preview of the replaced data itself.
yes Marc, I really agreed with you, about the safeguard that should be in there. But I think that feature also should be in PMA. So I would like to know, whether any body is working on that ??
Last edit: IsuruMadhu 2013-02-07
Not to my knowledge.
This feature has been implemented by https://github.com/phpmyadmin/phpmyadmin/pull/438/
Thanks for the suggestion.