Today I tried on my database the WITH QUERY EXPANSION clause on a fulltext search.
I manage the website of a famous italian soccer club (www.inter.it), and we
have hundreds of thousands of pictures of actual and former
players, coaches, events and so on.
Every day a back-office tool involve our web editors in finding
pictures based on captions. I developed such a feature using a
simple full-text search.
So, let’s try to find all pictures about “goalkeepers”
(unfortunately this word is not mainly used in picture
captions)
mysql> select count(*) from media where match(caption_en)
against('goalkeeper');
+----------+
| count(*) |
+----------+
| 60 |
+----------+
Let’s try now the same query using WITH QUERY EXPANSION
mysql> select …