NYCPHP Meetup

[nycphp-talk] Escaping MySQL full-text boolean mode search phrase

Cliff Hirsch cliff at pinestream.com
Thu Jan 11 13:12:42 EST 2007


How do I safely escape a search phrase string for a full-text IN BOOLEAN
MODE search?
 
Exampe:
 
SELECT * FROM table WHERE MATCH (field)
    -> AGAINST ('"the phrase"' IN BOOLEAN MODE);
 
If I use mysqli_real_escape_string, "the phrase" would become /"the
phrase/"
 
Ideas?
 
Cliff 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070111/09bf7782/attachment.html>


More information about the talk mailing list