Комментарии:
Great sir 💯
ОтветитьGreat 🤩🤩🤩
Ответитьsuperb explanation
ОтветитьHi, good Job, it's nice that you place the task / content in file with the data now, so that we know what's the task of the lesson
Ответитьselect * from feedback
where email like '[a-zA-Z]%@[a-zA-Z]%.[a-zA-Z]%'
and email not like '%[@#]%@[a-zA-Z]%.[a-zA-Z]%'
and charindex('.',REVERSE(email)) between 3 and 4;
Awesome! Find new concepts with great explaination. Thank you.
ОтветитьCommendable. Thanks for putting this much effort.
ОтветитьBrilliant! I'm loving this series. It's sending me into areas of SQL I never thought about.
ОтветитьYour videos are great.
Do you think you can also do a small tutorial video on REGEX with a couple more problems? I tried searching in your channel but could not find. It would be really helpful.
So cool! This is the first time I've heard about regular expressions and they seem super useful. Thanks for sharing!
ОтветитьWhat if I want to create a new column in an existing table with a REGEX formula to get the Invoice number from a column in that table.
ОтветитьSELECT email
FROM feedback
WHERE email ~ '^[a-zA-Z][a-zA-Z0-9_.-]*@[a-zA-Z]+\.[a-zA-Z]{2,3}$';
------ MySQL Solution ------
select cust_name, email
from feedback
where email REGEXP'^[A-Za-z][A-Za-z0-9_.-]*@[A-Za-z]+\\.[A-Za-z]{2,3}$' ;
Is there any fuuzy join in SQL?
Ответитьbest teacher ever
Ответить