-2

MATCH (FullTextSearch) AGAINST ('k*' IN BOOLEAN MODE)

return something

Namely anything with a word that start with k

MATCH (FullTextSearch) AGAINST ('ku*' IN BOOLEAN MODE) return less

MATCH (FullTextSearch) AGAINST ('kuc*' IN BOOLEAN MODE)

return even less

we figure that more should be returned if we just use *

MATCH (FullTextSearch) AGAINST ('*' IN BOOLEAN MODE)

returns nothing instead of what it should, namely EVERYTHING. Why?

Note: This means I have to specially code my sql command for empty string.

3

Per the MySQL Documentation on Boolean mode Full Text Search the aserisk wildcard is only applicable in the context of a word.

The engine is looking for a word that starts with whatever precedes the asterisk. Since there is nothing preceding the asterisk, and no words start with an empty string, you get no results.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.