Monday, 2 September 2013

SQL - How Do I Search a Sentence and Match by Keywords Separated by a Semicolons (a search like Google)

SQL - How Do I Search a Sentence and Match by Keywords Separated by a
Semicolons (a search like Google)

I currently have knowledge base articles in a database and the system
seperates the keywords relating to the article by a semicolon.
On the front facing form i have a text box limited to 100 characters. How
do i create a SQL query that looks at the words within the text box and
starts matching those words to the keywords within the database?
I basically want to create a search alittle like google one.
I am currently using like '%{token}%'. However this is not good enough.
Thank you.
Kindest Regards Wayne

No comments:

Post a Comment