MySQL tutorial for beginners 🐬 - MySQL wild cards are easy
4.0(1)
11 learners
What you'll learn
This course includes
2.5 hours of video
Certificate of completion
Access on mobile and TV
Summary
Full Transcript
#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%";
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.