On 12 Apr 2019, at 5:00pm, Tony Papadimitriou <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
