Member Avatar for rosalyn cruz

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

Edited by pritaeas because: Moved to MySQL.
  • 3 Contributors
  • 2 Replies
  • 116 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by chocolatte.lavista_1
Member Avatar for emilynlacao

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%';

Member Avatar for chocolatte.lavista_1

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, networking, learning, and sharing knowledge.