On http://www.liquibase.org/documentation/changes/update.html it is described how to build an UPDATE statement containing a WHERE-clause. however, it is not possible (an nowhere described) to build a complex WHERE-clause using AND/OR operator:
UPDATE cat.person SET address = NULL WHERE address = 'A String' AND sound LIKE '%meow%' OR loves = 'milk';
On http://www.liquibase.org/documentation/changes/update.html it is described how to build an UPDATE statement containing a WHERE-clause.
however, it is not possible (an nowhere described) to build a complex WHERE-clause using AND/OR operator:
UPDATE cat.person SET address = NULL WHERE address = 'A String' AND sound LIKE '%meow%' OR loves = 'milk';