Full Text Searches with Query Expansion

Orc · 12-19-2008, 02:20 PM

First off, this doesn't work. With or without a large collection of rows in a table. And everything is valid, Engine is MyISAM, the AGAINST argument is a string literal, my FULL Text column is TEXT and that is valid.

And by the way, I'm using PDO MySQL Driver for the querying procedure in case that affects the query in anyway.

And Yes I've tried IN BOOLEAN MODE which I don't seem to need at all, and even without Query Expansion.

Even if I add a keyword that's short enough to make the query work, it doesn't.

CoryMathews · 12-19-2008, 05:51 PM

If you remove the with Query Expansion so its just a match against does it still work? Also are all the columns you are searching aganist within the same full text index?

Orc · 12-19-2008, 08:31 PM

Quote:

Originally Posted by CoryMathews

If you remove the with Query Expansion so its just a match against does it still work? Also are all the columns you are searching aganist within the same full text index?

It isn't working... Otherwise I wouldn't have posted this, it won't return any rows, with or without query expansion it still doesn' return the rows, and yes they are.

Salathe · 12-19-2008, 08:34 PM

Give us some code (PHP & SQL), for us to re-create the problem, and we can move along from there. Without that, we've no idea what mistakes you might be making and "it doesn't work" is never enough to go on.

Orc · 12-19-2008, 08:39 PM

Quote:

Originally Posted by Salathe

Give us some code (PHP & SQL), for us to re-create the problem, and we can move along from there. Without that, we've no idea what mistakes you might be making and "it doesn't work" is never enough to go on.

The SQL won't help you. since it's just an average sql query for full text query expansion.. but w/e

sql Code:

SELECT * FROM `logs`
    WHERE MATCH (logmsg)
    AGAINST ( '".$o_Filter->slashes(urldecode($sq))."' WITH QUERY EXPANSION );