Full text search possible with DataAssist Keyword Search?
I have the following keyword comparison set up and working with one exception:
$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ("" == "") {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
$KeyArr1 = array("p.SearchString");
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_GET["Product"]))?$_GET["Product"]:"") ."","AND","Includes","%20",",%20","%22","%22",0);
I want it to display only whole word matches.
If someone types in Red Apple I want it to return only rows that contain both of these complete words in any order or location.
I don't want it to return barRed or grApple and other variations. Everything is working with this except that it does returning variations of the words.
Thanks for your help.
Jennifer