I'm building the where clause for the FAQS page as follows:
$Where = "WHERE (Question LIKE '%$SearchString%' OR Answer LIKE '%$SearchString%')";
This query only returns a match if all the search words are found in the Question field or if all the search words are found in the Answer field. Is there any way I can get the query to return a match if all the search words are found in the two fields combined (e.g., Question field contains "Why won't this work?", Answer field contains "I'm not sure.", and SearchString is "Why%not")?
First, if I continue going in the current direction, how do I break a user-submitted string into pieces that I can test?
Second, I read some info about match() against() statements. Is this method preferable to what I am trying to do now? If it is, how do I use the alter table statement to get a full text index, and does it permanently alter the table or is it a temporary thing?
P.S. Sorry for double-submitting my previous post. I clicked back and/or refreshed the screen after viewing the post.