QGIS: Error message in query builder

Question

I am using QGIS version 2.14.1 (Essen) and trying to update data in my table using field calculator.

I am inputing the following statement:

update "table_1" 
set  "table_1" ='y' 
where  "table_2" ='test'

But I get the following error message:

syntax error, unexpected COLUMN_REF, expecting $end

Anyone know where i'm going wrong?

Answer 1

If you select "table_1" for the Update existing field option, try using this expression:

if( "table_2" = 'test', 'y', "table_1")

Basically, you're using an IF THEN ELSE statement.