SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict mr.pita's Avatar
    Join Date
    Aug 2005
    Location
    USA
    Posts
    303
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Match against & plurals

    I'm doing a simple match against query against 3 fields, but I've noticed a problem when searching for plural words.

    For example, if I search for "penguin" I get 3 results about penguins, but if I search for "penguins" I get one result--the one result from the 3 that has the plural form of the word. It really seems to be behaving as if it were a LIKE statement.

    What I want to do, is have the search work for multiple forms of the word. I realize I could just add an "s" or take off an "s" and do an OR, but I don't want it to work just for plurals, but for similar forms of the same word. Is there any way to make it less sensitive?

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    fulltext boolean search might be what you are after

  3. #3
    SitePoint Addict mr.pita's Avatar
    Join Date
    Aug 2005
    Location
    USA
    Posts
    303
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ahh, I think you're right--I wasn't aware that existed.

    Thanks guelphdad!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •