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

[@BeNetCoders]

With "Similar To" you can actually have a range of characters, might be worth having this added into your next video you put out.. 👍
Select first_name, last_name
from customer
where first_name SIMILAR TO '[A-C]%'

[@victorgutierrez505]

This guy makes everything so clean... W

[@umarmuzammil7332]

love you bro demystified the topic

[@quangquyennguyen9390]

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

[@ironone4438]

Nice

[@lolman6976]

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

[@harryboskamp6670]

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.

[@mooners544]

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

[@FactManiacForYou]

first

[@OhYuuna]

Muito obrigada pela ajuda