The Joomla! Extensions Directory ™

DB Replacer Component

DB Replacer - search and replace in your Joomla! database.

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:

NoNumber extensions require php 5.3+
See for more requirements:

For support use the forum:
Do NOT use below reviews to post support requests or issues.

Report Extension



Reviews: 4
I needed to strip span tags from almost 1000 K2 items. I gave DB replacer a shot at the job. Got it installed in 2 minutes, but I couldn't figure out how to use the regex feature, so I posted a question on their forum. In less than an hour I received a response and had the work completed. It does not get any better than that.
Reviews: 5
So you've just built out 50 pages of content and the client comes back with "can we move A to B and change C... on every page".


Whilst you could write some complicated MySQL queries and do this in the database, being careful to escape all the necessary characters, it's much quicker and easier to use this component.

The ability to use WHERE clauses and regular expressions in the pro version lets you confine your searches to eg catid=10 and to find/replace items that vary from page to page (as long as they follow a predictable pattern)

I had an issue matching line endings and the developer came back within 24 hours with the solution (\s\s or \s+ in regex mode for anyone else having trouble with this)
Reviews: 20
Peter from NoNumber has provided extensions that are simply the very best for what they are intended for.

Peter also provides a level of support that is simply amazing.

A combination of a great product and great service will always foster growth, productivity and increased awareness.

I am very happy to rate this a 5+ extension for both productivity and customer service excellence.
Reviews: 3
Does exactly what it says it does - and does it well.
The preview is super - makes this tool much better than direct mysql statements in phpmyadmin.
Reviews: 6
This thing is brilliant. I used it to convert left over Wordpress code from a migration to Joomla and the thing is amazing. It seriously saved me over 100 hours of manually editing each post. A must have for any developer/designer. Also the support is second to none. I asked a lot of questions and at no point did I not hear back or get a "sorry, that feature isn't available" that you usually get. 5 stars.
Reviews: 5
Most of the extensions from NoNumber are indispensable, this one for sure...
I wanted to replace a complete tab content (VMD tabs) in about 1400 products with nothing, just delete a complete tab and all content. The syntax was slightly different in some cases but with a look at the forum and the use of some regular expressions I was able to do the job (costing days in a normal way) within one hour or so...
There are free versions (I'm a Pro User) of all NoNumber extensions available but one of these days I will buy a Lifetime Bundle for sure... It's wurth every penny and more, this guy is a genius...

Make a back-up before you use this extension, just in case!

Well done Peter!
Reviews: 1
I tried the free version and decided to upgrade to the PRO ver. because best fitting my needs. It's a truly helpful tool making (e-)life easier!
Congrts to the developer.
I recommend it.
Reviews: 13
After moving to another server I had a lot of broken links in my articles. All linked to one article that did not exist anymore. Fixing them one by one would have taken hours! With this tool I could fix them in a minute. I also decided to buy the PRO version! With that you can use WHERE statements. I used it to change the broken links only in ONE language.

The tool is really powerful and easy to use!
Reviews: 5
No words to describe this awesome free extension, that saved my days and nights of replacing via the known Joomla method tons of keywords about related articles...
Reviews: 3
We use this (free) extension frequently for our clients, as it easily replaces or updates data in the database. Very flexible and it does what it has to do.
Much more flexible than writing SQL code in phpmyadmin.

Peter really knows with his extensions what we webbuilders need! Thanx!

N.Roskam | Maxxima Internet
Reviews: 6
This extension is lifesaver. You can replate anything on your website in just one click. I had some characters many of my articles and I replaced them with just one click. Amazing
Reviews: 5
I have been using DB Replacer to correct and update data in several different fields of the database after migrating a big old 1.5 church site to 3.15.

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.
Reviews: 1
Saved me countless hours amending articles. I did a novice mistake, copy and paste from a word document. It put " " in every gap on every article 50+. Causing over-spill in my modules. DB Replacer just replaced them all with a space. Can't thank you enough.
Reviews: 2
Really a top notch tool for Joomla developers!
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!
Highly Recommended!
BTW - MAKE A BACKUP FIRST, you never know when yo might need it.
Reviews: 13
What can I say?
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...
Reviews: 3
Could not be more pleased. This extension is so easy to use. It can replace any content, (even keywords for SEO) with one click. This saved me literally three weeks of time, and my employer could not more happy. For $40 USD (DB Replacer Pro allows for the WHERE clause), it's a NO-BRAINER. Get it, you won't be disappointed, and the support is SPOT ON!
Reviews: 15
This tool is very useful to power administrators. With it you can easily replace something with something almost system wide. In example, you can fix broken static links on domain change.
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.
Reviews: 97
This is a very useful tool if you want to replace similar data which were scattered in many pages of your Joomla website.
Reviews: 6
I contacted Peter (developer) after updating Tabber to the new Tabs. The syntax had changed. He immediately pointed me to this awesome tool. Peter is definitely one of the top Joomla! developers out there - no question!
Reviews: 9
initially i downloaded the free version just to check it out. Almost immediately i paid for the PRO version. This is an awesome product and has already saved me HOURS of manual fixing - been able to search and replace Categories on Articles - work done in 2 mins... BRAVO NoNumbers ...
Page 1 of 3