lookup query

[ˈlʊk.ʌp ˈkwɪr.i]
nounpl: lookup queries
consulta de busca
1. A request or command to search for and retrieve specific information from a database, table, or system
The lookup query returned no results for that customer ID.
A consulta de busca não retornou resultados para esse ID de cliente.
2. In computing, a search operation that finds data based on specified criteria or parameters
The system performs a lookup query to verify user credentials.
O sistema executa uma consulta de busca para verificar as credenciais do usuário.
3. A reference operation used to find corresponding values or information in a lookup table or database
This Excel formula uses a lookup query to match product codes with prices.
Esta fórmula do Excel usa uma consulta de busca para corresponder códigos de produtos com preços.
This is predominantly technical jargon used in IT, database administration, and software development contexts. In Brazil, the English term 'query' is frequently retained even in Portuguese technical documentation, though 'consulta' is the formal equivalent. In both American and Brazilian tech communities, 'lookup query' is often abbreviated or shortened to simply 'lookup' in conversation.
Synonyms / Sinônimos
database querysearch queryreference lookupdata retrievalsearch request
Antonyms / Antônimos
insert querydelete queryupdate query

Regional Variations

General Brazilian
consulta de busca
Most common and standard term in Brazilian Portuguese
São Paulo
query de pesquisa
Technical/IT sector often uses anglicism 'query' directly
Rio de Janeiro
consulta de busca
Standard usage consistent with general Brazilian Portuguese
Portugal
consulta de pesquisa
Portuguese variant using 'pesquisa' instead of 'busca'

Related Words

SQL querydatabasesearch parameterindexresult setquery optimization

Related Idioms & Phrases

run a lookup query
execute a lookup query
optimize a lookup query
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →