String Functions in MySQL | Intermediate MySQL Series

In this lesson we are going to take a look at String Functions in MySQL!

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[benny]

I love when you specify when you actually use which functions at your real world job and when functions are less used. Gives a good idea of what is to come in a job

[SetYourBarTo]

Starting the day with a cup of coffee and Alex the Analyst.
Feeling good about today.

[HeinHtetAung-sy]

Very effective lesson with direct key points. Really appreciate your effort, Alex

[Adeola_Adegbesan]

Awesome session. I love the functionalities of these strings in data cleaning. Thanks Alex!

[kuanweili]

Thank you Alex. Just wanted to drop a quick note to say how much i loved your video

[aalanaa]

string functions are used to manipulate and work with text strings.
common string functions with real-world uses:

- CONCAT(): Combines multiple strings into one (e.g., full names).
- LENGTH(): Returns the length of a string (e.g., checking password length).
- LOWER()/UPPER(): Converts a string to lowercase or uppercase (e.g., email validation).
- SUBSTRING(): Extracts part of a string (e.g., area codes).
- TRIM(): Removes extra spaces (e.g., cleaning user input).
- REPLACE(): Replaces occurrences of a substring (e.g., updating city names).

[Bjellica]

Hi, Alex. Appreciate all you work here. Could you make a video regarding procedures and some use cases?

[habibullah]

You are a great teacher, Alex. Wish you all the best.

[BruceBeck-fn]

Hmmm... Wonder how I managed to get my comment about the UNION lesson in the String Functions lesson???? Guess I should have been paying more attention to detail...! That said, this lesson on String Functions of succinct and clear. Everything works as advertised and it all makes sense. Nice job Alex!

[YoanBello-rv]

Sorry one question, why in your roadmap abou data analyst you dont talk about Statistics skills. Thanks

[alig]

Hi Alex, I want to start learning Data analysis and the laptop I chose to buy has a i5 13420h cpu (16gb ram, 1tb ssd) What do you think about the cpu? is it good enough for me to get started?

[bankrow]

9:17 with the "REPLACE" is there any way to recognize both lower and uppercase?

[ashokdamodaran]

Hi Alex, i am having 10 years of experience as a Quality analyst in banking, can you please help me to suggest if self-study or doing a master's is a good option

[BruceBeck-fn]

Well, that was fun! Ending my day with Alex the Analyst while my lovely Bride is preparing dinner (I'm one lucky 'Wanna-Be-Data-Nerd'). Somehow UNION just makes more sense than JOINS for me. I just need more exposure and practice - like this Intermediate MySQL Series for example. Thanks again Alex! 😎

[ivanko-nebo]

Am I getting it right that in order to extract the month from the date using SUBSRTING the date should be in a string format, not a date?

[rahalvithanage]

Is there a way to make the first letter of all names UPPER and the rest LOWER?

[MD-mowb]

My 'Select' and 'From' are always lower case. Anyone else?

[MinatoJunior-hltb]

Can you show in mysql how to download csv files faster