0

My app have a table for Blog and News, i am able to perform a normal search in database with the LIKE keyword.

Example: SELECT * FROM Table WHERE Name LIKE '% JOHN %'

My task now is to retrieve records by searchnig with long sentence which may be news or blog title, blog post tags to use in retrieving related posts or user search from sql database but using the above query does not produce any result. Please what technique do i need to apply? Thanks

1 Answer 1

1

I think you should use a full-text search index.It should be a functionality of your SGBD. If you use SQL Server then you can activate the service, configure and use it.

Sign up to request clarification or add additional context in comments.

4 Comments

Pls how do i go about this task?
Hi, please have a look there : sqlserver
Thanks.. I have successfully implemented it, useful link
My pleasure @PrinceTegaton

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.