Wildcards в MySQL просты

Описание: #MySQL #курс #урок

% = любое количество случайных символов
_ = один случайный символ

00:00:00 %
00:01:55 _
00:04:00 заключение

SELECT * FROM employees
WHERE first_name LIKE "s%";

SELECT * FROM employees
WHERE last_name LIKE "%r";

SELECT * FROM employees
WHERE hire_date LIKE "2023%";

SELECT * FROM employees
WHERE job LIKE "_ook";

SELECT * FROM employees
WHERE hire_date LIKE "____-01-__";

SELECT * FROM employees
WHERE job LIKE "_a%";