Hi everyone and thank you for helping me... again :icon_neutral:

I am trying to perform a MATCH AGAINST sql query on one of my table called "what".

id (int 11) PRIMARY
org-id (int 11)
keyword (varchar 100) FULLTEXT
bid (DECIMAL 4,2)

I want to perform a search on the column 'keyword' with a keyword ($keyword) and order the - distinct - results with respect to the column 'bid'.

Right now I am using: SELECT DISTINCT `org-id` FROM `what` WHERE MATCH(keyword) AGAINST ('".$keyword."') ORDER BY `bid` DESC I don't get any error message but I don't get any results neither.

I think the problem might come from the fact that MATCH AGAINST ignores text that is contained in more than 50% of the rows and as of right now I only have 6 very similar rows.

What do you think?


Edited by jonathanroy: n/a

7 Years
Discussion Span
Last Post by jonathanroy
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.