String Functions in MySQL | Intermediate MySQL Series

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).

**Summary:** - `length(str)`: (int) Length of `str`. - `upper(str)`: (str) `str` converted to uppercase. - `lower(str)`: (str) `str` converted to lowercase. - `trim(str)`: (str) `str` trimmed from both ends. - `rtrim(str)`: (str) `str` trimmed from the right. - `ltrim(str)`: (str) `str` trimmed from the left. - `left(str, n)`: (str) The first `n` characters of `str`. - `right(str, n)`: (str) The last `n` characters of `str. - `substring(str, n, m)` (also `substr()`): (str) An `m`-long substring starting at the `n`-th character of `str`. - `replace(str, sub1, sub2)`: (str) `str` with all instances of `sub1` replaced with `sub2`. - `locate(sub, str)`: (int) Position of `sub` in `str` (1-based index). - `concat(str1, str2, ...)`: (str) Concatenation of `str1` and `str2`. ------------------------------------ **Bonus:** - `instr(str, sub)`: (int) Position of `sub` in `str` (1-based index). ---------------------------------------- Please let me know if there is anything wrong. Thanks!

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

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

Lesson#11 Conclusion So we have covered multiple string functions 1.LENGTH ==> This will calculates the total no. of characters present in the desired output 2.UPPER ==> To convert all the characters to uppercase form. 3.LOWER ==> To convert all the characters to lowercase form. 4.TRIM ==> Removes unwanted blank spaces from left and right. *LTRIM ==> Removes unwanted blank spaces from left side only. *RTRIM ==>Removes unwanted blank spaces from lright side only. 5.LEFT ==> To select specific character starting from the left side. 6.RIGHT ==>To select specific character starting from the right side. 7.SUBSRING ==> To select specific characters by mentioning start and end points. 8.REPLACE ==> To replace specific character with the desired character. 9.LOCATE ==> This will locate specific characters with 0 if not found 1 if found. 10.CONCATE ==> This will combine the characters of 2 different coloumns. SUBSTRING & CONCAT both string functions are very important and widly used in real world projects.

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

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

if anyone watching this right now, I would like to add one more -- CAST (x,y) x= value: y=datatype(signed(-inf - +inf), unsigned(0 - +inf), string, decimal etc.) helps to solve problems such as replacing numerical values in the dataset if any typo occurs, hope it helps : )

I'll definitely be coming back to this to remind myself about Locate, etc. Useful and direct as usual - thank you. I'd love a video on numeric functions when you have time <3

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