title: Update query in liquibase
body: <p>I need to run the below update query in liquibase, but I am not sure about the syntax. Can anyone please help:</p>
  
  <pre><code>update xyz.users
  set email = (select CONCAT(username, '@gmail.com ') "email"
  from xyz.users )
  where email like '%@yahoo.com%'   ;
  </code></pre>