[RESOLVED] MATCH AGAINST not working

[Dillenger]

Hello I have a database entry listingName = Serious Coffee

When I search for this I get a result:

SELECT * FROM listings WHERE MATCH (listingName) AGAINST ('(Serious Coffee)' IN BOOLEAN MODE)

When I search for this I don't get a result:

SELECT * FROM listings WHERE MATCH (listingName) AGAINST ('(Serious)' IN BOOLEAN MODE)

What am I doing wrong? I though Full text could match any part of a sentence?

[Dillenger]

Fixed it, I guess serious is a stop word

[leatherback]

for everyone else: How did you solve it? Could you please post the query that works for you

[Dillenger]

You have to edit the stop words file and remove serious... its in the mysql config file. That should fix it.

[leatherback]

cool.

Never noticed that before. It is a good day: I learned something new today!
Thx!

J