Join Bill Weinman for an in-depth discussion in this video Filtering results with WHERE, part of MySQL Essential Training (2014).
…Most of the time when you're getting data from a table,…you're looking for specific data, data that fits a particular, specific criteria.…The where clause gives you the tools you need to get…just the rows you're looking for, instead of the entire table.…Selecting the world database here.…In SID, and if we select everything from country like this, then…we get the 239 rows with all of the data in them.…This is a very rich table and it has a lot of information about each country.…
For example, if you want to know which countries have a…population under 100,000 it's easy to construct a query like this.…Let's get the name and the continent and the population from…country where population is less than 100,000,…and we'll order by population descending.…So when I press go, now we have a list of the…name, the continent and the population in order of the population descending.…
Just the countries with under 100000 of population.…So there's forty rows returned, and we know now…that forty rows in our table match that criteria.…
- 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.