Query fuzzy match

Extract from a sql database an exact match on a given field

Usage

query_fuzzy_match(tbl, field, values_q, con, n_fuzz = 1)

Arguments

tbl

tibble with one field listing names to be searched

field

string column name to be search

values_q

string names to be searched

con

PqConnection connection to RPostgres database

Value

A list of two elements, one with the extract if any, two with the names with id not NA when matched

Author

Gilles Dauby, gilles.dauby@ird.fr