# databaseUpdateAndLookup

Updates and looks up a value in a database.

The databaseLookupAndUpdate function updates a single value of the specified column that satisfies the specified condition and returns the value according to the SQL statement.

## Arguments

1. Name of the Talend Data Mapper database connection.
2. An UPDATE SQL statement that could be parameterized.
3. If you use a parameterized SELECT SQL statement, enter additional expressions that correspond to the parameterized ? character.

## Examples

| Expression | Result |
| --- | --- |
| databaseUpdateAndLookup("h2", "UPDATE countries SET country =<br>upperCase(country) WHERE country = ?", "FR") | FRANCE |