full text description search
[contractdashboard.git] / search_autosuggest.php
blob:a/search_autosuggest.php -> blob:b/search_autosuggest.php
--- a/search_autosuggest.php
+++ b/search_autosuggest.php
@@ -47,7 +47,7 @@
         );
     }
         $query = "SELECT \"CNID\", description, value FROM contractnotice
-WHERE to_tsvector('english', description) @@ to_tsquery('english', :input)";
+WHERE to_tsvector('english', description) @@ plainto_tsquery('english', :input)";
     $query = $conn->prepare($query);
     $agencyName = $input . '%';
     $query->bindParam(":input", $input);
@@ -84,3 +84,4 @@
     echo "</results>";
 }
 ?>
+