The purpose of this article is to provide examples “failed” search terms in table search as of late 2024, focusing on a MySQL FTS-backed service. In these cases, we know there is a target result we know exists and want to find.
I’m doing table queries here to show my desired results, but in reality, the users would be working on the data portal and only have “search” surfaced to them - they wouldn’t be working with the table directly.
search term | actual results | what I was looking for |
|---|---|---|
| ||
| ||
| ||
| ||