 <p>SQLite has no general mechanism to execute commands conditionally. However, in triggers, you can use a <code>WHEN</code> condition on the entire trigger:</p> <pre><code>CREATE TRIGGER test_for_broj_goluba AFTER UPDATE OF majka ON unos_golub BEGIN UPDATE unos_golub SET broj_goluba=NEW.majka WHERE broj_goluba=OLD.majka; END; CREATE TRIGGER test_for_majka AFTER UPDATE OF majka ON unos_golub WHEN NEW.majka &lt;&gt; '' BEGIN UPDATE unos_golub SET majka=NEW.majka WHERE majka=OLD.majka; END; </code></pre> <p>(The first <code>UPDATE</code> is the same in both cases and thus does not need a <code>WHEN</code>.)</p>