[@thedatakid1270]

Your channel is really good. Please keep uploading videos , I watch every video it's helpful to improve coding

[@agafow]

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

[@LearnatKnowstar]

Thank you

[@saktibiswal6445]

Really well explained although regex in MSSQL Server is very limited as compared to the regex functions in Oracle.

[@LearnatKnowstar]

Thank you 🙏

[@TriangleLife__Raj_Mrittik]

Thank you the documentation will help a lot

[@LearnatKnowstar]

Glad it was helpful!

[@diydecor2653]

Very detailed and clear explanation. The examples really help a lot. Thank you.

[@LearnatKnowstar]

Thank you

[@MethodOverRide]

Fantastic video! I didn't know the underscore could be used like that to create a pattern.

[@LearnatKnowstar]

Thank you 🙏

[@hasanmougharbel8030]

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.

[@KrishnaGupta-dd1mo]

I was looking for a regex SQL video. I found this. Really awesome video.

[@LearnatKnowstar]

Glad it was helpful 🙏

[@naziyatarannum7196]

Excellent explanation! Thank you so much 😊

[@LearnatKnowstar]

Glad it was helpful!

[@vishakhasingh3162]

Best explanation ever thanku so much ma'am 😘❤️🙏

[@LearnatKnowstar]

Glad it was helpful.

[@papachoudhary5482]

Great

[@LearnatKnowstar]

Thank you

[@Beyondhorizons-i5z]

Very well explained 🙂

[@LearnatKnowstar]

Thank you

[@duraimurugan-yy9hx]

Can you give an example for checking date format

[@kingstonxavier]

well explained! deserve more likes.

[@LearnatKnowstar]

Thank you

[@RamaKrishna-ll8iz]

`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

[@LearnatKnowstar]

Hi, Please follow the steps in this video - ruclips.net/user/shorts4hjFxdQpkbQ?feature=share

[@seasonz75]

Dear Ma'am, Please share the link for the dataset for this tutorial. Thanking you in advance.

[@LearnatKnowstar]

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

[@jaybuddhadev9889]

Helpful, thanks

[@LearnatKnowstar]

Glad it was helpful!

[@timmytesla9655]

Great video. Thank you!

[@LearnatKnowstar]

Glad you liked it!

[@sathyesh-si5vy]

Very useful🎉

[@LearnatKnowstar]

Thank you 🙂

[@anuragshrivastava7855]

same regex wont work in mysql?

[@nileshjadhav4396]

Good content. Keep uploading

[@LearnatKnowstar]

Glad it was helpful!

[@kashmirshadows8150]

Thank you

[@LearnatKnowstar]

Thank you for your support

[@akashkumarkashyap4850]

Could you please provide the data set

[@sandeepverma-qi6lo]

could you please make videos on plsql

[@LearnatKnowstar]

We have uploaded a recent video on stored procedures. Will be uploading more soon.

[@akumas23]

How about dynamic creation of json file

[@LearnatKnowstar]

Will plan to cover the topic soon. Thank you.

[@lakshmiprasad2990]

How can write a query to extract keywords from URL using this regex SQL query

[@happywhoopee]

Hey! Did you find the solution?

[@urvxfvdzrnp]

Great tutorial 👍

[@LearnatKnowstar]

Glad it was helpful 🙏

[@mohit189]

If you can answer my doubt....
You said '^abc' means 'not abc'
But i read on the internet that it means 'start with abc''

[@mitchelaraw7146]

^abc start with abc [^abc] not abc

[@kevinagdeppa4935]

Im confused. I thought the character "^" means the start of the character in REGEX

[@MethodOverRide]

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.

[@LearnatKnowstar]

It means start of character in Oracle regex which is much more powerful than for SQL Server.

[@mahesh_da]

Can you plz make the videos on python for data engineer. Plz help us for the python toics

[@LearnatKnowstar]

Sure. We are already working in the python tutorial videos and they will be posted soon 👍

[@prabhatgupta6415]

@@LearnatKnowstar please bring python questions as well mam

[@sivaprasadreddybojjireddy9831]

Thanks alot ☺️

[@LearnatKnowstar]

Thank you

[@lukendrak1581]

Thank u mam

[@LearnatKnowstar]

Glad it was helpful 🙏

[@kristyowens2284]

select from table where value like '%[^A-Z]%'

[@hv0032113]

Select * from table where col not like '%[^A-Z]%'

[@kavitadilse7286]

please upload the data for practice

[@LearnatKnowstar]

You can find data link and practice queries here- know-star.blogspot.com/2022/07/sql-regex-practice-queries.html

[@Shinzouille]

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 !

[@landchennai8549]

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

[@thedatakid1270]

Your channel is really good. Please keep uploading videos , I watch every video it's helpful to improve coding

[@LearnatKnowstar]

Thank you so much 🙏

[@pratik5648]

Thanks for the wonderful explanation

[@LearnatKnowstar]

Glad it was helpful!