SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE)
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 PostgreSQL Database i...
Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:
On this page of the site you can watch the video online SQL String Functions Tutorial (LEFT, RIGHT, POSITION, CONCAT, LOWER, REPLACE) with a duration of hours minute second in good quality, which was uploaded by the user Becoming a Data Scientist 09 January 2020, share the link with friends and acquaintances, this video has already been watched 49,829 times on youtube and it was liked by 1.1 thousand viewers. Enjoy your viewing!
