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: 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: 98
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 ...
Reviews: 4
I needed to change the background color and border color of some 500 tables. It would have taken me a week to finish the job. Utterly boring and disgusting work. Using DB Replacer, I finished the job in 2 minutes. Now for the rest of the week, I will just do nothing, and enjoy life.

Thank you for this extremely powerful and time saving tool.
Reviews: 6
Amazing for sure!!

Saves me a looot of job
Some clicks and done.
And when I need help the support was instantly

Well done
Reviews: 9
Very simple: probably this is not the kind of extension you'll be using everyday, but when you need it is extremely useful to have it installed.

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.

Wonderful extension!
Page 1 of 3