On 12 Apr 2019, at 5:00pm, Tony Papadimitriou <to...@acm.org> wrote: > update t set s = replace(s, 'USA', '___'), > s = replace(s,'US','USA'), > s = replace(s,'___','USA');
To add to the answers other people gave, there's no set order for SQL to process these changes. The SQL definition doesn't specify that they'll be done in any particular order. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users