How to do a smart lookup on a table?

Question

Java

It is necessary to make such a search: the choice of the column by which you want to search and the search field itself. How to implement such a search so that if you enter not completely, but for example a part of a word, then the search searches for all the fields that have this part?

Answer 1

If you do it "on the knee" then in SQL there is a comparison instruction LIKE and compare with the string sum of all fields separated by a space.
The bottom line - all fields in 1 line and check the occurrence of the desired in this line.