[PHP] Re: Search MySQL and Match Whole Words

2004-04-22 Thread Ligaya Turmelle
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 [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I was wondering if anyone knows how to do whole word searches in mysql. I have

[PHP] Re: Search MySQL and Match Whole Words

2004-04-22 Thread Matt Palermo
That will work if there is only one word in the column I'm searching, but the columns I'm searching are in paragraph form, so the = will not work there if I want to just match one word from the whole paragraph... Ligaya Turmelle [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] why not

Re: [PHP] Re: Search MySQL and Match Whole Words

2004-04-22 Thread Kenneth Dombrowski
On 04-04-22 19:48 -0400, Matt Palermo wrote: That will work if there is only one word in the column I'm searching, but the columns I'm searching are in paragraph form, so the = will not work there if I want to just match one word from the whole paragraph...