True, but SQLite3 is known to provide several conveniences that are not
necessarily standard SQL.
-----Original Message-----
From: Simon Slavin
Sent: Friday, April 12, 2019 7:11 PM
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