Igor Tandetnik wrote: > > You don't need SELECT keyword here. You could also get closer to the > original statement with > > UPDATE tableName SET rgt = rgt + (CASE WHEN (rgt < %1) THEN %2 ELSE -%3 > END); >
This also has the advantage that it is standard SQL and therefore portable to many other database systems, not just mySQL. Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
