Member Avatar for jonathanroy

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?

Jonathan

Edited by jonathanroy because: n/a
  • 1 Contributor
  • 1 Reply
  • 135 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by jonathanroy
Member Avatar for jonathanroy

I've inserted dummy rows and it works fine. Ooops.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.