Enter in the Search text box the existing text that you want to replace. You can replace the searched text with something else, or simply remove it (by replacing it with nothing).

DB Replacer - Search & Replace

Then enter the new replacement text in the Replace text box, and click the Search Button.

The Preview window at the bottom of the page will now show you a preview of the replacement, showing the rows which contain your search string. The original search string will be marked red and the new replacement will be marked green.

DB Replacer - Preview

If you are satisfied with the Preview result, you can simply click on the Replace button to apply the changes.

Note: You can search and replace in up to 1000 rows at one time (up to 50 in FREE version). WE RECOMMEND to not set the default row count limit too high (around 100). Replacing in too many rows at once can make your page time out, depending on server and database settings.

Special search words

DB Replacer comes with a couple of special syntaxes you can use in the search area:

You can match the entire value of a field by placing a single asterisk * in the search area.

You can match empty, NULL or 0000-00-00 date values by simply placing NULL in the search area.

Case Sensitivity

Unlike direct MySQL replacements, DB Replacer has the advantage of making case-insensitive replacements. The replacements made by DB Replacer are case-insensitive by default.

This means that ‘Joomla’ would also match ‘joomla’ and ‘JOOMLA’.

However, if you need to make changes where case sensitivity is required, you can check "Case sensitive" checkbox. If you switch on that setting, replacements will only be done where the search matches exactly.

So in this case, ‘Joomla’ would NOT match ‘joomla’ or ‘JOOMLA’.

Regular Expressions PRO

The PRO version of DB Replacer also supports the use of Regular Expressions to search and replace.

This gives you great power to search for dynamic values and use (parts of) the searched text in the replacement.

For example, if you want to make all prices with syntax $123.00 bold, you can search for:

(\$[0-9]+\.[0-9][0-9])

And replace with:

<strong>\1</strong>

This will make $1.00 and $999.00 bold, but ignore $1 and $999.

When the Regular Expressions option is checked, you will also be able to search in UTF-8 mode. This can help you when using special characters or certain character sets.

More on Regular Expressions

For help and documentation on regular expressions, ReReplacer comes with a Regular Expressions Cheat Sheet.

For more info on Regular Expressions: http://www.regular-expressions.info/reference.html
For testing them: http://gskinner.com/RegExr, http://regexpal.com, http://www.phpliveregex.com