Learn how you may find the length of a string using the nonstandard LENGTH() function or its equivalent on your system.
- [Instructor] While the SQL standard does not include…a function for finding the length of a string,…most modern database systems do include one,…and it's usually called length.…So for this lesson,…we'll use the world database,…and I'm just going to type in a simple select statement.…Select length of, and the literal word string,…in single quotes, and a semi colon.…Now, I'll press go and you see…the length of string function returns the number six,…and there are six characters in the literal string, string.…
The length function is really very simple.…It takes a string as its one argument…and returns a number representing the length of that string.…Of course, this is much more useful as part of a query.…So I can select name,…and length of name,…as length,…from city order by the length, descending, and name.…
So, this'll give us a list…of all the name columns from the city database,…sorted by the length of the name,…and within that length by the alphabetical name itself.…So, when I press go,…Google Chrome clearly wants to translate this page for me.…
Author
Released
7/2/2018- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
Duration
Views
Related Courses
-
Introduction
-
Welcome1m 16s
-
Exercise files2m 21s
-
Course overview1m 38s
-
-
1. Installation
-
Installing on Windows: Part II10m 16s
-
Installing on a Mac: Part I6m 45s
-
Installing on a Mac: Part II12m 10s
-
2. SQL Overview
-
About the overview3m 39s
-
Database organization2m 54s
-
The SELECT statement5m 49s
-
Selecting rows2m 3s
-
Selecting columns1m 29s
-
Counting rows2m 42s
-
Inserting data3m 9s
-
Updating data2m 28s
-
Deleting data1m 42s
-
-
3. Fundamental Concepts
-
Creating a table3m 40s
-
Deleting a table2m 14s
-
Inserting rows3m 31s
-
Deleting rows1m 55s
-
The NULL value5m 22s
-
Constraining columns3m 17s
-
Changing a schema2m 3s
-
ID columns2m 21s
-
Filtering data5m 43s
-
Removing duplicates2m 37s
-
Ordering output2m 23s
-
Conditional expressions2m 30s
-
-
4. Relationships
-
Understanding JOIN2m 19s
-
Accessing related tables4m 31s
-
Relating multiple tables4m 27s
-
-
5. Strings
-
About SQL strings1m 33s
-
Removing spaces2m 26s
-
Folding case2m 13s
-
-
6. Numbers
-
Numeric types3m 32s
-
What type is that value?2m 12s
-
Integer division1m 56s
-
Rounding numbers1m 2s
-
-
7. Dates and Times
-
Dates and times1m 52s
-
-
8. Aggregates
-
What are aggregates?4m 38s
-
Using aggregate functions1m 57s
-
Aggregating DISTINCT values1m 53s
-
-
9. Transactions
-
What are transactions?2m 2s
-
Data integrity3m 10s
-
Performance3m 27s
-
-
10. Triggers
-
Preventing updates2m 36s
-
Example: Timestamps2m 26s
-
11. Views and Subselects
-
Creating a subselect3m 47s
-
Creating a view3m 32s
-
Creating a joined view2m 32s
-
-
12. Defined Functions
-
Overview1m 7s
-
Defining functions in PHP4m 27s
-
-
13. A Simple CRUD Application
-
Embedding SQL4m 50s
-
The SELECT functions3m 30s
-
-
Conclusion
-
Goodbye1m 3s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Finding the length of a string