[sqlite] Update with out without WHERE?

[Gert Van Assche]

Hi all,

When I do an update in a huge table, should it write it like this
        UPDATE T1 SET F1=replace(F1, 'x', 'y') WHERE F1 LIKE '%x%';
or without where clause like this
        UPDATE T1 SET F1=replace(F1, 'x', 'y');

T1 has an index on F1, which is a TEXT field.

thanks

gert