SQL Tutorial - 41: SUBSTR(), RIGHT() & LEFT() Functions

In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.

[@dontmesswithmeeeee]

I'm just getting started with SQL and I appreciate your tutorials , because they are straight to the point, no details to complicate the topic additionally! Well done.

[@fudgymcfudgerson6291]

are you an sql pro now 5 years later?

[@omarfetooh2657]

simple and easy , thank you

[@mamtakumari2707]

Thank you

[@manoramapanorama]

Watched all your videos! You're amazing:)

[@alulahabesha7207]

Thanks man

[@rajeshk5534]

Thanks for this video very help full

[@trishasingh8832]

ThANKYOUU!

[@jattgamers4985]

Nice 👍

[@nitinrawat7581]

Mja aaya.....ty bro

[@vidyajethwa4278]

Thanks.. it helped a lot😊

[@ASHOKSHARMA-yn4gl]

Very useful..Thank you

[@abbadfareen5360]

Thanks sir

[@priyafoujdar4877]

Really helpful sir..

[@bartekzduninho8314]

I work with oracle and left function doesn't work. Have no idea why."select left(last_name,5) from employees"

[@iamfutureflashx]

Great

[@AnimesOtakusAMV]

how can I use this inside a MYSQL function, I'm trying this way, and it's not working, declare diaAtual = SUBSTR(dataAtual, 1, 2);

[@rajgopalacharim7098]

what if i do not mention th elength in substr like slect substr('PRACTICALS',3);

[@BabitaMishra888]

Helo sir can we use both left and right same at time if yes how ? Plz help