Hi, my installation:
I need to know the requirements used to search for a ticket by the customers.
Example: If customer searches the word "test 5" he gets:
It’s not correct for me
But, if customer searches “immagini” he gets:
it's correct
Thank you
Giulia_arc
In MySQL a space is considered a stop word and will break apart the search phrase. In your case it will split "test 5" into two parts "test" and "5" and search through all records and return all matching objects and order by relevance. To avoid this and search full phrases you can wrap the term in double quotes (ie. "test 5") and it will treat it as a full phrase and should return results that match only this.
"test 5"
Cheers.
