Re: Search MySQL and Match Whole Words
| From: | Ligaya Turmelle | Date: | Thu, 22 Apr 2004 23:44:05 +0000 |
| Subject: | Re: Search MySQL and Match Whole Words | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184318@lists.php.net to get a copy of this message | ||
why not just use WHERE word = "inputWord" and skip the whole LIKE thing for
an exact match? Is that what you mean?
Respectfully,
Ligaya Turmelle
"Matt Palermo" <webmaster@sweetphp.com> wrote in message
news:20040422212640.11873.qmail@pb1.pair.com...
> 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