Join Bill Weinman for an in-depth discussion in this video String functions, part of MySQL Essential Training (2014).
…MySQL provides a wide variety of string functions for use in your queries.…I'll cover the major ones here.…In this lesson, we'll be using the world database.…We'll start with a simple query that get's…the length of the LocalName from the Country table.…And so we're going to SELECT and we'll get both Name and LocalName.…But we're just going to take the length of the LocalName, using the LENGTH function.…And we're selecting just for WHERE Continent equals…Europe, so we have a manageable list of countries.…
And we'll order it by that length and you'll notice…that I gave the LENGTH an alias, using the AS clause.…I'm using that AS clause for the ORDER BY.…So, we don't have to use the whole LENGTH function twice in the query.…We'll order descending, so that the larger ones are at the top.…And I'll press Go.…And here we have our lengths.…And so you can see the LocalName here, and the Length of the local name.…And here's something interesting to notice.…
Let's get down to some of the smaller ones.…You see the ones with accented characters.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- 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.Cancel
Take 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.