Filter Content with WHERE - Know the Code

Unlock your potential with a Pro Membership

Here is where you propel your career forward. Come join us today. Learn more.

Login to your account

Skip to episode playlist

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';

view raw where.sql hosted with ❤ by GitHub

Your best friend is code, Tonya is making the introductions.

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

Back to the lab's opening page.