DB Replacer enables you to search and replace in any table in your database.
It even supports searching with case sensitivity.
Sometimes you need to replace something in all your articles. That takes hours doing it the conventional way: open article, change, save article, open next article, etc...
With DB Replacer this takes a few seconds.
DB Replacer gives you a preview of what is going to be replaced, so you know what you are doing before actually replacing anything.
WARNING: DB Replacer replaces stuff right in your database in the places you tell it too. This can - if you replace the wrong stuff - break your site. So be careful and only use this if you know what you are doing.
How to use it: http://www.nonumber.nl/dbreplacer
NoNumber extensions require php 5.3+
See for more requirements: http://www.nonumber.nl/dbreplacer#requirements
For support use the forum: http://www.nonumber.nl/forum
Do NOT use below reviews to post support requests or issues.
Much more flexible than writing SQL code in phpmyadmin.
Peter really knows with his extensions what we webbuilders need! Thanx!
N.Roskam | Maxxima Internet
As I backed up the database each time before using it, I felt very confident and after a good amount of use it has been successful.
I had an issue that it only works with the default Isis Admin template (not the Hathor one) and Peter the developer could not have been more helpful with this and another issue. Mind you, by the time I got his personal support I had purchased the Pro version, which was what I planned to do anyway (as it is even better) and for such a serious task as editing inside the database it was well worth the money.
Not only have I saved lots of time but I have also increased the new website quality by a good margin.
Well done Peter and thanks.
I needed to fix the image tags in about 160 articles on a new site.
This component is very very cool.
It allowed me to specify the string for which to search, and as I typed it in and specified the target table, it highlighted the changes that it was going to make so that I could pre-approve the changes.
The free version only does 50 records at a time, but it works very well, so I just did it three times.
THANKS for this EXCELLENT Component!
BTW - MAKE A BACKUP FIRST, you never know when yo might need it.
To handle with care. You better know what you are doing and keep track.
But seriously, So much use cases.
You won't need it everyday.
But you will sleep peacefully knowing you have this one ready.
Was of great help for an upgrade from 1.5 to 2.5, after having used an extension to import most of the site, used DBReplacer to adapt components and do minor corrections and stuff.
I guess you can drive your joomla site from there...
That i dont like about it, is that as far this extension evolves, its actually becomes less and less feature complete - features previously available for free in 2.1 ("Where" option and regexp) was removed in later free version, moved to paid version. I appreciate developers hard working but i doubt this is right way.
Thank you for this extremely powerful and time saving tool.
I had several posts where I needed to make a change. Using the built-in search and replace functionality I could change several lines of code in more than 70 articles in less than 5 minutes.
What else can I say. It works beautifully, and it's extremely easy to use.
Extremely powerful as you can make changes to all your articles in a matter of seconds. In my case I replaced a content plugin and had to modify the syntax in all articles. It was a single operation with DB replacer.
Now one other thing I will also mention in other reviews for NoNumber extensions:
As soon as you have more than one NoNumber extension installed I highly recommend his extension manager!
So, after migrating a site (using sp_upgrade), I then rearrange the images directory to a structure of my liking. Even if it's a simple move up in the folder tree.
db_replacer allows me to quickly change all [src="images/stories/] to [src="images/]
While I am at it, if I decide to rearrange or rename image folders, it is a simple src="images/old_folder/ replaced by src="images/new_folder_name/
If I needed it more frequently, like for changing affiliate links or branding, I would get the pro version in an instant. For my one-time use, it was still worth a donation.
Thanks for saving me hours of tedious work (or having to do the sql query myself)