How to implement a good full-text search on the site?

Question

Search Engine Optimization

Now the site uses the following search code code:

OrgModel::whereRaw(
        "MATCH(name_org,description,tags) AGAINST(? IN BOOLEAN MODE)",
        array($string)
    )

But somehow bad looking.
When requesting "store number 9" - he is looking for all stores, but not store number 9.
What am I doing wrong?

Answer 1

Look towards search engines: for example, sphinx

Answer 2

Try IN NATURAL LANGUAGE MODE instead of IN BOOLEAN MODE.

Answer 3

Read the query language help.
In this case, a search with quotation marks "shop #9" will give an exact match.
This can be sewn into the request, or you can write a hint to the user.
But you will not get a good search from the basic functionality.
If you need a simple search string, then probably the laziest option is Yandex.Search. At least everything is ok with morphology. The only problem is that it searches only for the indexed one.

Answer 4

You can try '+shop +#9'
operators
about search engines