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 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 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
