How to implement a simple search function

You can enter your nickname, mobile phone number, question content, and email address in the search box of a background search function, is there any way to improve efficiency in different tables? One background search function
Enter your nickname, mobile phone number, question content, and email address in the search box.
Some contents have different dimensions and are also in different tables.
Is there any way to improve efficiency?

Reply content:

One background search function
Enter your nickname, mobile phone number, question content, and email address in the search box.
Some contents have different dimensions and are also in different tables.
Is there any way to improve efficiency?

If the data volume is small, you can create a full-text search table in the database to store the data you need to query. If the data volume is large, you can use open-source search tools, such as lucene. The lucene-based solr is also quite simple.

Oh, it hurts.
Simple-brainless method: drop all the content to be included in the cable collection into a table. The disadvantage is that the cable receiving speed is slow when the data volume is large.

The third is the use of third-party cable collecting software. For php, you can use tools such as sphinx. It is easy to implement and can also be segmented. The disadvantage is that it is a little troublesome to configure, And the dictionary should be maintained by itself. However, this type is recommended.

For full-text search, try domestic search