How can I use the query of SQL “contains” for searching the value by specific keywords or phrases?

 In SQL you can use the “SQL CONTAINS query” for searching the products in your dataset by just using the specific keywords or even phrases. Here is the example given of how you can do so:-

Let us consider a scenario where you have a table whose name is “products” with the column name “description”. In this particular scenario, your objective is to find the product which contains the word or phrase “waterproof”. You can do so by using SQL contains query:-

SELECT *
FROM products
WHERE CONTAINS(description, ‘waterproof’);

This above SQL query would print you for the product or products which have the phrase included “waterproof”. In other words, this query will retrieve all the rows where the description would contain the specified word or phrase.