Search %LIKE% with leading & trailing spaces
I'd like to do a search on a description field, for example looking for the word "sea", but I don't want to see results such as "research", only those that match " sea " as an isolated word surrounded by spaces.
I can fix most things on my own, but this is driving me a bit nuts!
Any help anyone please?
Here is the related code ...
Thanks!
==================== CODE ===========================
$KeyArr1 = array("w_desc");
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["descriptionSearch"]))?$_POST["descriptionSearch"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);