Using wildcards in MySQL fulltext searches
Posted on 2008-10-02
I'm using a MySQL database, and I have a table containing a text field. I was using a query to return all rows containing a string within the text field -
... WHERE desc like '%MSDN%'
But this is was too slow on a large table. I speeded this up by using a fulltext index on the 'desc' column in my table.
However, the equivalent fulltext search clause
... MATCH desc AGAINST ('MSDN')
returns rows matching
I've tried modifying my fulltext search with wildcards i.e.
... MATCH desc AGAINST ('*MSDN*')
but this didn't work, I still didn't get the complete set of matches I expected. Does anyone know what the equivalent fulltext search pattern is, to return exactly the same resultset as my original query?