http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
Only works with certain table types. Not InnoDB tables (transactional) for instance.
Best, Mattias
(ps.... new to this list - messed up on replying first time)
-------- Original Message --------
I was wondering if anyone knows how to do whole word searches in mysql. I have a search textbox that users can enter in multiple words to search for in the database, but things like the mysql LIKE match any part of a word. Is there a way to search for whole word matches only? Please let me know if you can help.
Thanks,
Matt http://sweetphp.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php