How to improve the search function?

Question

PHP

Good afternoon everyone, I'm doing a small simple live search, in the input for searching after entering two characters, a script works that displays everything found in the following image:

$db_referal = $mysqli -> query("SELECT name FROM product WHERE name LIKE'%$referal%'");

As a result, it gives out the entire line containing the search word.

while ($row = $db_referal -> fetch_array()) {
        echo "\n<li>".$row["name"]."</li>";
    }

How to make it so that it does not output the entire line, but only the word? The search goes on one field, one table (as you can see from my query), and the field contains a sentence. And from the sentence it is necessary to extract exactly the word that satisfies the desired result.

Answer 1

you already have the word (from the search bar).