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