# databaseLookup

Looks up a value in a database.

The databaseLookup function returns a single value of the specified column that satisfies the specified condition 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 |
| --- | --- |
| databaseLookup("h2","SELECT country FROM countries WHERE country\_code =<br>?", "FR") | France |