I am redoing part of the system's search for full-text search. By comparing the results from the different search options, I found that the fulltext does not return all the results. In the example (link) I have a part of the records where I want to find "568" in the fields kod, kod2, kod3, kod4, kod4, kod6, kod7, kod8, obj_cis_zbozi.
I have created two fulltext keys, where one is for the name (the other part of the search) and the other is the fulltext key, it is on the specified fields - see example.
LIKE search returns me all results, but using fulltext is no longer successful. I can't figure out why.
sample build http://sqlfiddle.com/#!9/521b17/2
EDIT
I will add one more example http://sqlfiddle.com/#!9/a5a13f/3 where I divided the fulltext index into individual fields. From the second example, you can see in more detail what the score in the search for each field is.
I absolutely do not understand why some fields do not score when the field value contains the search string.
It seems to me that the score is only there if the word starts with that string.
How to get results if the search string is in the middle of a word ?
I tried searching *568*
, but the result was the same.
Can someone please explain why there is no search for some fields