DB Replacer

Where statements

3 months 2 weeks ago #78513

Johan Hammarström's Avatar Johan Hammarström

Hi,
I need to change the catid from 14 to 44, but only on certain records with certain words in title...

I set Columns to "catid" and set "14" in search and "44" in replace. Then I set the where statement to "catid = 14" (if I do not set that where statement it also finds catid 144, for example), but I need another where statement to find only the articles with, for example, "musik" in the title... I am not too familiar with the where statements, but I tried to set where statements to "catid = 14 AND title = "musik", but that didn't find any articles...

Please advise.

With kind regards,
- Johan.

3 months 2 weeks ago #78514

Peter van Westen's Avatar Peter van Westen Admin

Try:

catid = 14 AND title LIKE "%musik%"