Back
Query.search limitation
Since string is deprecated I used varchar, and now I cant use Query.contains , so I setup fulltext index and started using Query.search
the issue is Query.search is very bad at searching, if I have string abc-123 then I have to write abc to get the row, otherwise no other way will match such as bc or 123
I guess it have an issue with special characters or numbers. or it's just bad at doing search.
TL;DR
Developers are experiencing issues with the Query.search function, specifically when trying to search for strings with special characters or numbers. The function is not returning expected results and seems to struggle with such inputs.