New feature: Search + replace on table rows
An interesting new feature for users who avoid writing UPDATE queries. And of course for those who want the power of regular expressions with callbacks when modifying table rows.
Thanks to klorinczi for the idea!
That would be enabled if 'data grid' would be selected and would contain list of columns in grid, like (as per attached image):
Ok there is workaround = change query to contain only column which you want to mod by regex, but that is not handy.
Anyway I tried in upper case, where the contence of table is constantly changing (delete all, add a bunch of new records), hence a bunch of errors popped up on 'replace all' command.
I guess there is no lock on table when you clic 'replace all' ?
I think lock should be done.
Point beeeing - I see a big plus of this search & replace & regex thing. It should enable you to do what you can't do in mysql at all, without writing extra program for that.
But, as it is wery likely that I would do regex update based on things that I see in other columns, I don't want them to be hidden.
Obout LOCK from other posts above, I think the best flow would be:
1.click replace all
3.reselect based on query (as data mybe changed while looking at dialog)
Please login to leave a reply, or register at first.