How can I create a text input with autocomplete and then display data from mysql database in express?

So, I have a form, in which the user will select inputs. Firstly, I want to create a text input and in this when the user writes for example A, it will suggest every data from the MYSQL database that starts with A etc. The page of the form is /air_tickets and then the user will be redirected to another page.

File structure:

How can I create a text input with autocomplete and then display data from mysql database in express?

Inside the views folder, there are all my .ejs pages (html).

air_tickets.ejs