Menu

#1405 (ok 4.1) Find and Replacing column wise

Needs_decision
fixed
nobody
None
1
2013-12-12
2013-02-03
IsuruMadhu
No

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

Discussion

  • Marc Delisle

    Marc Delisle - 2013-02-03

    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.

     
  • IsuruMadhu

    IsuruMadhu - 2013-02-07

    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
  • Marc Delisle

    Marc Delisle - 2013-02-07

    Not to my knowledge.

     
  • Isaac Bennetch

    Isaac Bennetch - 2013-07-05

    This feature has been implemented by https://github.com/phpmyadmin/phpmyadmin/pull/438/

    Thanks for the suggestion.

     
  • Isaac Bennetch

    Isaac Bennetch - 2013-07-05
    • summary: Find and Replacing column wise --> (ok 4.1) Find and Replacing column wise
    • status: open --> resolved
     
  • Isaac Bennetch

    Isaac Bennetch - 2013-07-05
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2013-12-12
    • Status: resolved --> fixed