Description:
#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%";
Share this link via
Or copy link