MySQL fulltext search not returning all matching results
I'm using MySQL 8.2 and I've got a table called records for which I added the following index in order to perform text search on it: CREATE FULLTEXT INDEX all_records_idx ON records (`title`, `label`, `description`, `catalog_number`,`barcode`); Now, I've got the…