Sure. A LIKE operator tells SQL that you want to bring in records that are similar, not an exact match, to whatever value you determine. For example, you are using a database of cookbooks. You only want the titles that have apple in it:
SELECT BookTitle, Author
FROM CookBooks
WHERE BookTitle LIKE '%apple%'
The "%" is the SQL wildcard for any character(s).
Hope this helped.