how to use sql like operator?how to use it give me example thanks!

hi ate LIKE operator is used in a WHERE clause to search for a specified pattern in a column,and also used to search for a specified pattern in a column.

example:SELECT * FROM Customers

WHERE Country NOT LIKE '%land%';

example : SELECT * FROM Customer WHERE Country LIKE '%M';

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.