Search: “wp_query” (Page 8 of 29)

When retrieving data, there times where you may want to change the WHERE clause in WordPress. That is, depending on what you’re retrieving, you may want to filter what it’s searching.

And that’s exactly what a `WHERE` clause does. But just as we’ve looked at content in other posts, we can alter the `WHERE` clause via the WordPress API.

In previous posts, I’ve covered:

– Displaying the last query, which is useful when doing light debugging.
– Selecting `DISTINCT` records
– Performing a `JOIN` on two tables

Here, I’ll show how to use the API to change the `WHERE` clause so you’re not having to do so through a custom query.

In a previous posts, I’ve talked about how to:

– View the last query that WordPress executed
– Select `DISTINCT` records in WordPress

There’s a lot more to do than just viewing the last query and selecting distinct rows, though. For example, you can also JOIN two tables in WordPress without having to write raw SQL.

So to be consistent with some of the previous posts, I thought I’d share how to do this using the WordPress API .