On 12/13/2011 6:38 PM, BareFeetWare wrote:
If depends on what your statement 1 and statement 2 are. Let's say that they
are update statements, then your above example would look something like:
update tableX set column2 = 'match' where "column" = 'foo';
update tableX set column2 = 'no match' where "column" != 'foo';
Or better still:
update tableX set column2 = (case when "column" = 'foo' then 'match'
else 'no match' end);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users