I want to input search keywords to search a table field in a database, and return the results if the table fileld's value has the full input search keywords.
Such as, if I input the search keywords as "hello world",
I want all the following records being returned as search results. (In simple words, return results have "hello world" but not the "hello world's most beatiful model!")
Hello world Hello USA, How are you doing? (the search keyword is at the beginning of the field value. I am thinking about using LIKE '$keywords %')
or
Hi, we use Hello World to welcome our guests. (the search keywords are in the middle of a sentence. LIKE '% $keywords %')
or
Say, Hello world. Say Hi, World.(the search keywords are in the end of sentence. using LIKE '% $keywords' but this also will bring up "hello world's most beatiful model!")
or
Hey, "Hello World" is the message. (the search keywords are wrapped in double quotes or single quotes.)
or
... Hello World!, Hello world; Hello world: (the search keywords are followed by some punctuations.)
It got have an easy way to do a general sense words search.
Any help?
Thanks!
