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

[BroCodez]

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

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

[victorgutierrez]

This guy makes everything so clean... W

[quangquyennguyen]

wheel of fortune :)) that wy I like your course bro :))

[lolman]

hey bro code great video thank you for giving us the best content
but I have a question what extensions do you use on your ide

Edit: VS Code sorry not the other IDE you use

[harryboskamp]

Your last 5 videos aren't visible in my subscription feed. i am subscribed and rang the bell. i only found out that you uploaded any new videos from the home page.

[mooners]

Heya bro! I was wondering if you could upload your videos to Odysee? There are a ton of coding channels on there and a lot of people who would enjoy your content.

[Nxtfbrdf]

2:22 gay/bi boys like myself are you familiar with the term at this timestamp