Let me start out by explain the tables
kb_Author 'Author of the Article
kb_Status 'Active or Inactive
kb_ID 'KB ID -> Link to tbl_kb_data_Header (Many)
kbd_Type 'Type of record (Summary, Cause, Resolution)
kbd_Data 'KB Data for the type.
So, the standard KB record will have one header record, and up to 7 detail records..
Here's my problem (Using MySQL 4.1.1 by the way)..
I need to be able to do a search on the tbl_kb_data_Detail.kbd_Data because this is where the document details come from. The problem I am having is that if the user does a search for TWO words.. Lets just say their search string is "ASP SessionVariables".
If the the word ASP is in the first Detail record, and SessionVariables is in the second detail record, it will not find this.. Because it is looking for both words in each record.
I need the SQL statement to think of the Entire KB document. So one header with many different detail records..
This could pose a BIG problem for the project I am working on, so I am hoping you might have some insight..
Thanks in advance,