How can I do a exact wording search?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Kwok
    New Member
    • Jun 2006
    • 12

    How can I do a exact wording search?

    I want to search a keyword in a content stored in a table, which the content is a abstract of a report

    I want to search a keyword by exact word such as:
    User input : news report
    The result will only shows content with "news report" instead of "news reporter"
    I try to add a space to the keyword
    i.e.
    SELECT * FROM data WHERE content LIKE '* " + keyword + " '*;"
    How ever this cannot search the keyword in the beginning of the content and also the word in the last of the content
    e.g.
    cannot search "News report" in content "News report is a News report"

    Can anyone help a newbie like me?
    Thanks a lot~
Working...