SQL Regex Complete Tutorial | Practice with 20+ SQL Queries | Pattern Matching | Regular Expressions
ฝัง
- เผยแพร่เมื่อ 1 ม.ค. 2025
- In this tutorial, we learn about the SQL Regular Expressions.
We also write 20 + Practice Queries.
The SQL queries discussed in this tutorial can be found here -
know-star.blog...
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate
imp.i384100.ne...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org
Your channel is really good. Please keep uploading videos , I watch every video it's helpful to improve coding
Thanks for the wonderful explanation
Glad it was helpful!
Excellent explanation! Thank you so much 😊
Glad it was helpful!
I was looking for a regex SQL video. I found this. Really awesome video.
Glad it was helpful 🙏
Very detailed and clear explanation. The examples really help a lot. Thank you.
Thank you
Great
Thank you
Fantastic video! I didn't know the underscore could be used like that to create a pattern.
Thank you 🙏
Well done video!! I have problem similar to this. i have 8 digits numbers i want categorize first two numbers, example 01-05, then 06-15, and so on. thank for your efforts
Thank you
Helpful, thanks
Glad it was helpful!
Really well explained although regex in MSSQL Server is very limited as compared to the regex functions in Oracle.
Thank you 🙏
Very well explained 🙂
Thank you
Very useful🎉
Thank you 🙂
Great video. Thank you!
Glad you liked it!
Good content. Keep uploading
Glad it was helpful!
Best explanation ever thanku so much ma'am 😘❤️🙏
Glad it was helpful.
well explained! deserve more likes.
Thank you
Great tutorial 👍
Glad it was helpful 🙏
Hey, god bless your efforts.
I have a simple enquiry as a newbie.
How can i identify the character set of a special language that contain special characters.
Is that related to data type assignment.
Also, how can encompass special characters from different character set at once.
Thanks for taking care of my enquiry.
Can you give an example for checking date format
Thanks alot ☺️
Thank you
could you please make videos on plsql
We have uploaded a recent video on stored procedures. Will be uploading more soon.
Thank you
Thank you for your support
Could you please provide the data set
How about dynamic creation of json file
Will plan to cover the topic soon. Thank you.
Dear Ma'am, Please share the link for the dataset for this tutorial. Thanking you in advance.
You can download the AdventureWorks database from Microsoft website at the below link - learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
Can you plz make the videos on python for data engineer. Plz help us for the python toics
Sure. We are already working in the python tutorial videos and they will be posted soon 👍
@@LearnatKnowstar please bring python questions as well mam
Thank u mam
Glad it was helpful 🙏
`Hi madam, i have downloaded backup file. could you please help me how to upload/import that back up file to server.
i am local server(Windows authentication). I have 10 databases. if i import/attach/download backup file is there any chance those previous 10 databases will be lost
Hi, Please follow the steps in this video - th-cam.com/users/shorts4hjFxdQpkbQ?feature=share
same regex wont work in mysql?
If you can answer my doubt....
You said '^abc' means 'not abc'
But i read on the internet that it means 'start with abc''
^abc start with abc [^abc] not abc
How can write a query to extract keywords from URL using this regex SQL query
Hey! Did you find the solution?
Im confused. I thought the character "^" means the start of the character in REGEX
This is TSQL pattern matching not Regex like one might use in Python or C#. It's similar, but not nearly as powerful based on my experience with it. But it's what you have available to use with TSQL PATINDEX etc.
It means start of character in Oracle regex which is much more powerful than for SQL Server.
please upload the data for practice
Select * from table where col not like '%[^A-Z]%'
select from table where value like '%[^A-Z]%'
What a joke ! RegExp ? Really ? You'd better specify in your title that it's MS-SQL ! It's not really REGEXP so limited, even MySQL is better and totaly free !
Pull PANNUMBER from the String:
declare @Panumn table(Id int identity(1,1), Pan varchar(32))
insert into @Panumn values ('CUHPP8945R'),('qsqCUHPP8945Rcsd')
select *
, substring(Pan,PATINDEX('%[A-Z][A-Z][A-Z][A-Z][A-Z][0-9][0-9][0-9][0-9][A-Z]%',Pan),10) as ExactPan
from @Panumn
Thank you the documentation will help a lot
Glad it was helpful!
Your channel is really good. Please keep uploading videos , I watch every video it's helpful to improve coding
Thank you so much 🙏