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]

Reply via email to