Matching patterns is a very important and useful ability. In this article, we look at how you can match patterns using the SQL LIKE operator. Pattern matching is a very simple concept. It allows you to search strings and substrings and find certain characters or groups of characters. You can find pattern matching mechanisms in SQL and in other programming languages. In this article, we’ll examine how the LIKE operator can be used to search substrings.