Explore

I am trying to understand the MySQL fulltext search function (MATCH) and I do not understand why I get the records that does not "match" the search phrase. SELECT name FROM song WHERE (MATCH(name) AGAINST('*Spending my*' IN BOOLEAN MODE)) ORDER BY name ASC; When I execute this query it returns me a lot of (259 records) that does not even match the search phrase,...

Published at LXer: The system�s man pages contain a wealth of useful information. But sometimes it�s hard to see the wood for the trees. Even experienced users can be bamboozled by the sheer...