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
  • 134 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by chocolatte.lavista_1

Dani AI

Generated

Good follow-ups to the question from — thanks to and for the starter examples. A few practical tips and extra examples that are useful years later: how to match single characters, escape literal percent/underscore, force case sensitivity, and avoid performance traps.

Example patterns (different scenarios):

-- find users at a specific domain
SELECT id, name FROM users
WHERE email LIKE '%@example.com';
-- underscore matches exactly one character
SELECT sku FROM products
WHERE sku LIKE 'ABC_1_%';
-- escape an underscore so you search for the literal character
SELECT * FROM filenames
WHERE filename LIKE '%!_%' ESCAPE '!';

To force case-sensitive matches on non-binary columns use BINARY or a binary collation:

SELECT * FROM accounts
WHERE BINARY username LIKE 'Admin%';

For more complex patterns (alternation, character classes), use regular expressions:

SELECT * FROM logs
WHERE message REGEXP 'error|failed|timeout';

Performance and gotchas:

  • Leading wildcards (%foo) generally prevent use of an index; foo% can use a left-anchored index. For lots of substring searches, consider FULLTEXT indexes or external search engines.
  • % matches zero or more characters; _ matches exactly one character.
  • The default case-sensitivity depends on the column collation; do not assume LIKE is case-sensitive.
  • Escape characters let you search for literal % or _.

Official reference: MySQL pattern matching docs

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.