Learn how the WHERE clause allows you to filter rows from your result rather than returning all the rows in a table. Discover WHERE is often used with the LIKE and IN clauses.
- When you query a database, more often than not…you're looking for specific data,…data that fits a specific criteria.…There where clause allows you to get…just the rows you're looking for…instead of the entire table. For this exercise,…we're going to use the world database and I'll…select everything from country, so our country table.…You see this is a very rich table.…It has a lot of information about each country.…For example, if I want to know which countries have a…population of under 100,000, it's easy to…construct a query like this. I can select…name, continent, and population from country where…population is less than 100,000 and…order by population descending.…
"DESC" stands for descending.…Now when I press go, I get just the countries…where the population is less than 100,000…in descending population order.…The where clause takes a Boolean expression,…that is rows are returned only if the Boolean expression…evaluates as true for that row.…Notice that we're missing some countries from the list where…the population is unknown or very small,…
- 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
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- 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.