Search MySQL and Match Whole Words
| From: | Matt Palermo | Date: | Thu, 22 Apr 2004 21:26:38 +0000 |
| Subject: | Search MySQL and Match Whole Words | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-184303@lists.php.net to get a copy of this 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