Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Article:
  MySQL FULLTEXT Searching
Subject:   Fulltext seach and joins
Date:   2004-10-12 13:34:35
From:   johnv8
Response to: Fulltext seach and joins

Slight error with that query, I meant to say:


SELECT *
FROM fulltext_table AS FT
INNER JOIN other_table AS OT ON OT.id = FT.id
WHERE
OT.id = 123 AND
MATCH(FT.text) AGAINST ('search_string') LIMIT 1000