what is use of like in SQL

Answer 1

You can use "LIKE" Operator to find similar results for the Word you have entered, OR you can fetch results from database containing the Word you entered.

Ex.,

SELECT * FROM Customers
WHERE Country NOT LIKE '%land%';

Answer 2

Remember to use the % sign. (note to self:))