Hi Peter & co,

I wanted to delete the value of a given custom field (with ID 6) for some Articles (with ID < 101)

So I was quite confident that the following would work:

table = fields_value
column = value
where = field_id=6 AND item_id<101
search = ^http
regex = ON
replace = test

but in the "preview" at the bottom of the screen, it seems to simply replaceby, not "the whole string" by(and actually what I want to do is not to replace by "test" but by "", ie empty string)

The regex works! Thank you so much 🙂

But without regex, just putting * would also display 33 results... but the preview seemed totally wrong

See the difference

- with regex


- without regex

oh, interesting.
I did not dare executing * bc of the weird appearance in the preview, I was not aware of this subtlety
Txs again for everything.
Issue closed 🙂

oh, very smart, txs a lllot Peter, as always 🙂