09 MySQL Tutorial for Beginners: LIKE + REGEXP Operators, Regular Expressions

You use the LIKE operator to retrieve rows that match a string pattern. The Mask for a LIKE phrase can contain special symbols called "wildcards". Masks aren't case-sensitive.

In contrast to the LIKE operator, the REGEXP operator allows you to create complex string patterns known as regular expressions.
The mask for a REGEXP phrase can contain special characters and constructs like:
- the "caret" (^) symbol matches the pattern to the beginning of the value being tested.
- The "dollar sign" ($) symbol matches the pattern to the end of the value being tested.
- The "pipe" (|) symbol separates two string patterns and matches either one.
- "Square brackets" [] are used to specify multiple values.
lf you use the NOT keyword, only those rows with values that don't match the string pattern are included in the result set.

EXERCISES for your SELF-TRAINING:

SCRIPT FOR THE EXAMPLES:

SUBSCRIBE!

FACEBOOK

GOOGLE+

[RDobani]

Wow man, thank you so much, this is exactly what I was looking for. Keep up the great work!

[annaaniska]

This is best regexp explanation I have seen so far

[gulnaroguz]

This video deserves a millions of views! Thank you!

[ericklozano]

Great definitions and examples. I had to speed the video up at 1.75x but everything else was spot on. Thank you for this video.

[SaadAli-igqn]

Amazing Job man. Saved me a lot of time going through multiple videos.

[prfm_setya]

no clickbait, to the point, great! thanks btw sir

[oLars]

Great explanation and visuals, thank you so much !

[bananaboydan]

Great video! just what i was looking for, thanks a lot

[sug_madic]

i know it's 7 year old but i appreciate you work

[christianrodier]

I will give a thumbs up to that. Good stuff

[sandhyag.a]

$qry="select classid from examtab where classid like '".$roll."%' and classid like '%".$branch."%'";
how can I write the above query in crct way?
where classid will b of the form:1322CSE....here 13 is roll n branch is CSE...

[bibekanandasahoo]

can you please explain this '^[abcd].*en$'

[RuslanSkiraUkraine]

great thank you very much. And I look such operators like * . and other with examples if somebody such great lessons with * and . please attach the link)