Join Bill Weinman for an in-depth discussion in this video Filtering results with regular expressions, part of MySQL Essential Training (2014).
…Regular expressions provide a very…powerful pattern-matching mechanism, much more…powerful than the simple like patterns and also much more complex.…Regular expressions are actually a pattern-matching language.…It's an incredibly useful feature and it's also a very large subject in itself.…In this movie I'll give you a brief overview of the…power of regular expressions, but I'm really just scratching the surface.…For a more complete discussion of regular expressions.…The lynda.com Online Training Library has an excellent…course called Using Regular Expressions with Kevin Skoglund.…
If you watched the lesson on…like expressions, you may remember this statement.…I'm going to select the world database here.…And.…Select name, continent, population, from country where…name like underscore a percent order by name.…And we'll press go and here we have a list of all of…the countries with an a in the second letter of their name in order.…
Now suppose instead of just.…The letter A in the second position, you wanted all the names with an…
- 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.