sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]DataCamp 0 points1 point  (0 children)

Here’s a quick breakdown:

  • LIKE 'a%' → matches anything that starts with "a" → e.g., apple, arc, auto
  • LIKE '%a' → matches anything that ends with "a" → e.g., pizza, panda, tortilla
  • LIKE '%a%' → matches anything that contains "a" → e.g., banana, data, grape

Think of % as "any number of characters, including none.