How to implement live search for ios application in php API?

Question

PHP

I am writing an API for an iOS application, I need to implement live search in the client and in the API. As I put it, in the client we send each entered character to the API, and there in the API there will be a script that makes a request to the database and returns all data from two fields that begin with the received character. The database stores only words, no phrases or sentences. The structure of the base is
+---------+-------------+------------------+--- ------+
| word_id | word1 | word2| user_id |
+---------+-------------+----+------ ---+
| 110 | mainWord | testExtraword | 101 |
| 111 | mainWord | testExtraword2 | 101 |
| 112 | mainWord | Google | 101 |
Programming language for API php 5.4;
DBMS Mysql 5.5;
iOS Objective-C ios SDK;

Answer 1

Where is the question? :)
According to what was said now:
1) In any case, you need to kill for such field names, nothing is clear :)
2) If you want to do a search, it's better to use existing tools, such as Shpinx or elasticsearch. This is an order of magnitude better and better than doing LIKE in sql database.

Answer 2

api and live search are not connected in any way ─ network delays are too large, the user will only be nervous in vain, send the phrase (part of the phrase) right away, do not spell it. Live search is more for the client, among already cached data