How can I search SQL database using long sentences

Question

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

Khaled · Accepted Answer · 2015-12-18 23:19:36Z

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.

answered Dec 18, 2015 at 23:19

Khaled

4213 silver badges10 bronze badges

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

4 Comments

Prince Tegaton Over a year ago

Pls how do i go about this task?

Khaled Over a year ago

Hi, please have a look there : sqlserver

Prince Tegaton Over a year ago

Thanks.. I have successfully implemented it, useful link

Khaled Over a year ago

My pleasure @PrinceTegaton

Collectives™ on Stack Overflow

How can I search SQL database using long sentences

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related