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

Soluzione

SQL Like

Soluzione