. Hello, My table's columns are: [ID, VALUE, MODIFIED]
How can I make the following update in sql (Its probably easy but i don't achieve it ). i have a int= new_value
UPDATE FROM table SET value = new_value,modified= if (new_value==VALUE) then 0 else 1;
Query the original data and use an if-else statement.
if(originalValue == newValue) {
// Update query
}
else {
// Update query
}
Why not evaluating if it is modified outside the sql:
int isModified = newvalue != VALUE ? 1 : 0;
And in SQL:
UPDATE FROM table SET value = new_value, modified = isModified
In regular SQL you can do it like this:
UPDATE tablename
SET value = new_value,
modified =
CASE
WHEN new_value = value THEN 0
ELSE 1
END
But I'm not sure if SQLite supports CASE
