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
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.