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... > http://dev.mysql.com/doc/mysql/

[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

[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