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

Reply via email to