SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)
HTML-код
- Опубликовано: 27 сен 2024
- A step-by-step video tutorial on the most popular SQL string functions like CHAR_LENGTH, LEFT/RIGHT, CONCAT, POSITION, UPPER/LOWER, and REPLACE!
List of string functions:
Queries:
1) Get the number of characters in a string: SELECT CHAR_LENGTH(column1) FROM table
2) Get a certain number of characters starting from the left: SELECT LEFT(column1, 5) FROM table
3) Get a certain number of characters starting from the right: SELECT RIGHT(column1, 5) FROM table
4) Get the position of a character in a string: SELECT POSITION(' ' IN column1) FROM table
5) Combine strings together: SELECT CONCAT(column1,' ',column2) FROM table
6) Make all the characters in a string lowercase: SELECT LOWER(column1) FROM table
7) Make all characters in a string uppercase: SELECT UPPER(column1) FROM table
8) Replace characters in a string: SELECT REPLACE(column1,' ','') FROM table
Get the Northwind Database: • How to Load a Sample P...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:
Of all the SQL videos out there, yours have been the most helpful to me!
Thank you for these great tutorials! Can't stress how much I appreciate these.
i realize it's pretty randomly asking but do anybody know a good site to stream new tv shows online?
@Shepherd Angel Flixportal =)
@Braden Jefferson thanks, I signed up and it seems to work :D I appreciate it!!
Great job. Your videos are really helping me to understand SQL. THank you for your time!!!
Your way of teaching is pretty cool. Love it :)
Thanks, these videos are short and to the point, and so very helpful!
It was really helpful. God bless you
Yo, where did the SQL joins tutorial go? I clicked on this video (seeing "LEFT") and though it was the joins one but I can't find it anywhere
Which was a great video btw, really carrying my IT mark
Great video and explanation! Thank you so much - keep the good content coming my friend!
This was great, clear and concise
Thank you. You are awesome!
Thank you, watched a few of your SQL videos now and they're all really well explained!!
Very helpful, great video
really appreciate the knowledge
really awesome videos during my learning journey, so helpful!
Nice, just got in and it says sql error.... lovin it
Thank you !
Great video!
Really helpful, thanks a lot!
very help!
I want to see all the data when you replaced then what will be the syntex
thanks mate.
Explain lag and lead function please! Thanks in advance
Very helpful, thanl you
this is so good!!!
Awesome Videos: I am new and came across this: Any wisdom on how to display? Thx
it is in a cell labeled info
Hey Sir, what about the those who has the middle name and if we want to separate middle name as well ?? Could you please make a video on that as well. Thank you!!
Likewise, companies that tack the suffix onto the last name.
@@RIVEXNGLE use MID & POSITION
How can you find the position of a space in a name
Great video! Really appreciated seeing the example of using the combination of left, right, char_length and position to separate first and last name
You are using Postgres, but if you use another db, these functions are spelled the same?
Thank you for this very useful video!
Thank you. Really helpful! :)