# databaseLookupAndUpdate

Looks up and updates a value in a database.

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

## Arguments

1. Name of the Talend Data Mapper database connection.
2. A SELECT 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 |
| --- | --- |
| databaseLookupAndUpdate("h2", "SELECT country FROM countries WHERE<br>country = ?", "FR", "france") | France |