Full-Text Searches with Query Expansion

[xbl01234]

Hello;
I am trying to use the "Full-Text Searches with Query Expansion" with the following code, but it always miss some rows or does not bring out any result, Could you tell why, please.

SELECT * FROM articles
 WHERE MATCH (title,body)
 AGAINST ('database' WITH QUERY EXPANSION);

or for user don't known how to spelling

 SELECT * FROM articles
 WHERE MATCH (title,body)
 AGAINST ('databa' WITH QUERY EXPANSION);

The above code from
[dev.mysql.com ]
and create table and insert value from
[dev.mysql.com ]

Thanks

[mcibor]

Have you checked

[dev.mysql.com...]

?

Or you can always use LIKE '%databa%'

PS.
Note: Because blind query expansion tends to increase noise significantly by returning non-relevant documents, it is meaningful to use only when a search phrase is rather short.

What version on mySQL do you have?
For 4.1 check
[dev.mysql.com...]

Regards
Michal