Prince Tegaton Prince Tegaton - 1 year ago 77
SQL Question

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

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download