On 25 Nov 2012, at 4:11pm, Imanuel <my_mailings_addr...@gmx.de> wrote:
> Hi Keith > >> UPDATE user SET a=1,b=2,c=3 WHERE a||b||c!=1||2||3; > > It seems to me that this is not reliable. > Think the the following text values: > a='12' > b='34' > c='56' > > If you want to update these values to: > a='1' > b='2345' > c='6' > > Then your statement would not update because '123456' = '123456'. You're quite right, but in some cases it's sufficiently faster than doing WHERE a!=1 OR b!=2 OR c!=3 that even with the false hits it takes less time to process. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
