The **LIKE** operator is used with `WHERE` to search for some pattern in a string.

The pattern is usually some kind of [Regular Expression](https://docs.python.org/3/howto/regex.html#simple-patterns) that is built with some rules, but we won't dive deep into it. In the meantime, the following rules are enough for you:

 - `%` means 0 or more symbols: `a%` matches `a`, `aa`, `aaaaa`, etc. `b%d` matches `bd`, `bad`, `bored`, etc.
 - `_` matches single symbol. `t_ee` matches `tree`, `twee` etc, and `_o%_` match `wow`, `coooow`, `soap` etc., but not `so` for example.

In this example all singers with the naming of two separate words, both consist of at least one symbol.

SELECT singer FROM songs
WHERE singer LIKE '_% _%'

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Like

解答