Search and select fields . Get the data from database

Hey everyone !
I’m working on app . My goal is to create a list and each field should be search field .when user search i want it to open a small list (limit the result because its big file) that loaded from the database then the user can find it and select it easly.

I tried to use ion-autocomplete but didn’t succeeded to achieve my goal
First how should i approach the server side should i get first that table convert to json and echo and then use it as a big object and filter and so or its better to fire specific query each time user search ?

And what its the best approach to accomplish my goal that each field on the list will be like a search bar,filtered ,clickable . Thanks alot !!

What server side technology are you using?

Hey thanks for the replay. I use mysql and php