Update query in liquibase

Question

I need to run the below update query in liquibase, but I am not sure about the syntax. Can anyone please help:

update xyz.users
set email = (select CONCAT(username, '@gmail.com ') "email"
from xyz.users )
where email like '%@yahoo.com%'   ;

Answer 1

try this

<update tableName="xyz.users">
    <column name="email" valueComputed="(select CONCAT(username, '@gmail.com ') 
from xyz.users)"/>
<where>email like '%@yahoo.com%'</where>
</update>