Select in Datasource to retreive only one row

I have 2 collumns in a single calc spreadsheet. The first is a number code for a company (a primary key). The second, I must populate with the name of this company.

I also have one table with 2 fields into a MySQL, accessed thought jdbc by my Libreoffice.This table have 2 fields: company_id is the first one and it’s a number, the primary key of the register. company_name, the second one, it’s the name I must retreive to the calc spreadsheet.

How can I query the mysql db, using the first column of the spreadsheet to retreive the company_name to put at second column?

Would you take the entire table from MySQL on a separate sheet in the workbook (just drag it with the mouse to a blank space), and then use a normal VLOOKUP() in the second column to find the correct value?

(Answer for resolution)

As @JohnSUN comments above:

[Why don’t] you take the entire table from MySQL on a separate sheet in the workbook (just drag it with the mouse to a blank space), and then use a normal VLOOKUP() in the second column to find the correct value.