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%“;
Back to Top