Another full text search problem (php mySQL related)

Discussion in 'PHP' started by instyle, Aug 2, 2006.

0
  1. #1
    Hi,

    I am using full text search supported by php and mysql. I know there must be a solution to match following two words (for example) simultaneously,

    print vs prints

    Now my code won't catch 'print' if I search 'prints' and vice versa. Is there a solution to this?

    Thanks a lot,

    inStyle
     
    instyle, Aug 2, 2006 IP
  2. Gordaen

    Gordaen Peon

    Messages:
    277
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #2
    In your query you can do something like
    WHERE CONTAINS (blah, '"print*" ')
    (substituting the variables in obviously), but then you may want to do checks for sizes... hmm, maybe someone else has a better way?
     
    Gordaen, Aug 2, 2006 IP