469,658 Members | 1,801 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

FULLTEXT inconsistency

I have a FULLTEXT index.

when i query it for a specific item, i get different results in
phpMyAdmin, vs a PHP search app I'm developing.

In the PHP search app, the match I expect isn't returned (in fact
nothing is returned), though in phpMyAdmin, the exact match i expect
is returned -

the query i am using to test this is specific enough to isolate the
result to one match.

Here is my query:

SELECT product_id as id, product_name, MATCH(product_id,
product_name,
notes,
material,
manufacturer,
country)
AGAINST ('+(>$search_term*)' IN BOOLEAN MODE)
AS m FROM quick_search WHERE MATCH(product_id,
product_name,
notes,
material,
manufacturer,
country)
AGAINST ('+(>$search_term*)' IN BOOLEAN MODE)
ORDER BY m DESC, product_name ASC
also, in my search app, if i search for something that doesn't exist, i
get tons of bad results - but in phpMyAdmin, i get 0, which is what i'd
like in the search app.

any clues to what's going on here, given the queries are identical?

thanks,
s7

Jan 9 '07 #1
1 2019

st******@hotmail.com wrote:
I have a FULLTEXT index.

when i query it for a specific item, i get different results in
phpMyAdmin, vs a PHP search app I'm developing.

In the PHP search app, the match I expect isn't returned (in fact
nothing is returned), though in phpMyAdmin, the exact match i expect
is returned -

the query i am using to test this is specific enough to isolate the
result to one match.

Here is my query:

SELECT product_id as id, product_name, MATCH(product_id,
product_name,
notes,
material,
manufacturer,
country)
AGAINST ('+(>$search_term*)' IN BOOLEAN MODE)
AS m FROM quick_search WHERE MATCH(product_id,
product_name,
notes,
material,
manufacturer,
country)
AGAINST ('+(>$search_term*)' IN BOOLEAN MODE)
ORDER BY m DESC, product_name ASC
also, in my search app, if i search for something that doesn't exist, i
get tons of bad results - but in phpMyAdmin, i get 0, which is what i'd
like in the search app.

any clues to what's going on here, given the queries are identical?

thanks,
s7
i fugured out the missing result problem, but not the part about
getting seemingly all the results when there is no match (which doesn't
happen in phpMyAdmin).

the first problem had to do with using an include file that limited the
results. i suppose the second problem is also php/app related.

thanks,
s7

Jan 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Phil Powell | last post: by
reply views Thread by Wesley Hobbie | last post: by
reply views Thread by Ralph Guzman | last post: by
reply views Thread by Matt W | last post: by
reply views Thread by Phil Powell | last post: by
reply views Thread by Alex Glass | last post: by
reply views Thread by Robert Oschler | last post: by
1 post views Thread by Robert Oschler | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.