I am using Full-Text searching with In Boolean Mode. I am generating
my query by using binding parameters. If a user types in a quoted
string on the search form (in order to match that string as-is), the
binding mechanism escape it with a backslash. The query runs fine and
it appears to return the same results when I run the same query by
hand without the backslashes. I just want to make sure these
backslashes are not being interpreted differently and that the
full-text search engine is treating the double-quotes as they are
intended (and not looking for them literally)
E.g.
... AND MATCH (title, description) AGAINST ('chev* \"malibu\"' IN BOOLEAN MODE)
vs
... AND MATCH (title, description) AGAINST ('chev* "malibu"' IN BOOLEAN MODE)
They both seem to be Ok, but I just want to make sure now, before
wierd problems come up later...
thanks
-william
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]