Unlock your potential with a Pro Membership
Here is where you propel your career forward. Come join us today. Learn more.
Filter Content with WHERE
Lab: Introduction to Databases
Video Runtime: 08:24
In code, you use conditional expressions to make decisions and determine which tasks to run. SQL gives you this same ability. You use the keyword WHERE
like you would when using an if
in PHP. Let’s talk about how you filter to grab the content you want.
SELECT ID, post_title | |
FROM wp_posts | |
WHERE post_type = 'portfolio' AND post_status = 'publish'; |
When was the last time you got out of your chair and stretched? Just saying…
Episodes
Total Lab Runtime: 02:08:59
- 1 Lab Introductionfree 05:17
- 2 The Big Picturepro 14:35
- 3 Your First SQL Querypro 12:21
- 4 WordPress to Database Relationshippro 20:20
- 5 Filter Content with WHEREpro 08:24
- 6 Table Alias with ASpro 05:08
- 7 Defining Table Structure (Schema)pro 12:17
- 8 Create a New Database Tablepro 10:23
- 9 WordPress Schemapro 05:11
- 10 Exploring WordPress Queries with Query Monitorpro 07:14
- 11 SQL to Get a Custom Fieldpro 16:41
- 12 SQL to Update Custom Fieldpro 05:14
- 13 Wrap it Upfree 05:54