Where clause [pro] - Tutorial - DB Replacer

Where clause PRO

With the PRO version of DB Replacer you can limit the search via a custom WHERE clause.

The WHERE clause is used to extract only those records that fulfill specific criteria.

This field follows the default MySQL WHERE syntax. For instance, if you only want to search and replace in articles inside category with ID 5, you can do:

catid = 5

To search and replace in records that have an ID between 100 and 200, you can enter:

id > 100 AND id < 200

Or with string values:

name = "Mike" OR username LIKE "%mike%"

You may include an optional leading WHERE. SQL comments, statement separators, and write or DDL keywords are rejected. A rejected clause produces an invalid-query error and is never silently omitted.