CODEWITHSUNDEEP
sqlasp.netsql-server
Prince Tegaton
Prince Tegaton

Reputation: 322

How can I search SQL database using long sentences

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

Upvotes: 0

Views: 205

Answers (1)

Khaled
Khaled

Reputation: 421

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.

Upvotes: 1

Related Questions