MySQL wild cards are easy

#MySQL #course #tutorial

% = any amount of random characters
_ = one single random character

00:00:00 %
00:01:55 _
00:04:00 conclusion

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%”;