Query by post_title

[wonderboymusic]

If you are using wp_posts as an object store, sometimes you want to do an exists lookup by "name" or "title" - here's what doing that now looks like:

$tacos = get_posts( [
  'post_type' => 'taco',
  's' => $name,
  'exact' => true,
  'sentence' => true,
  'post_status' => 'publish',
  'fields' => 'ids',
  'posts_per_page' => 1
] );

I don't want to hear any arguments about performance without an acknowledgment that LIKE wildcard searches against serialized meta_values exist.

[SergeyBiryukov]

Related: #33065

[wonderboymusic]

33074.diff​ accomplishes this

[wonderboymusic]

In 33706:

Query:

Add a query var, title, that allows you to query posts by post_title. To accomplish this now, you have to do something like:

$tacos = get_posts( [
  'post_type' => 'taco',
  's' => $name,
  'exact' => true,
  'sentence' => true,
  'post_status' => 'publish',
  'fields' => 'ids',
  'posts_per_page' => 1
] );

Adds unit tests.

Fixes #33074.

[dimadin]

Replying to wonderboymusic:

Missing changelog. There is already a changelog for 4.4 from when post_name__in was introduced ([33653], [33661]), so maybe just expanding it?

[wonderboymusic]

In 33722:

WP_Query: add changelog for the title param after [33706]

Props dimadin.
Fixes #33074.