[wp-trac] [WordPress Trac] #53450: [WP_Meta_Query] Add faster LIKE based 'STARTSWITH' and 'ENDSWITH' compare modes for value query

[WordPress Trac]

#53450: [WP_Meta_Query] Add faster LIKE based 'STARTSWITH' and 'ENDSWITH' compare
modes for value query
-------------------------------------------------+-------------------------
 Reporter:  janthiel                             |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Query                                |     Version:  5.7.2
 Severity:  trivial                              |  Resolution:
 Keywords:  dev-feedback has-patch needs-docs    |     Focuses:
  needs-codex has-unit-tests early early-like-   |  performance
  actually-early                                 |
-------------------------------------------------+-------------------------

Comment (by ironprogrammer):

 Hi, @janthiel! Thanks for sticking with this enhancement. As you know 5.9
 was a little late, but I think this can be refreshed and ready for 6.0.

 There have been several DocBlock updates to `WP_Meta_Query` that presented
 merge conflicts during recent testing of this PR. Would you be able to
 refresh off latest `trunk`? You can also update to `@since 6.0.0` 🤞🏻

 Nice work on the unit tests! I think they could be a little more
 consistent by using `factory()->post->create_many`, `$query`, and
 `$expected` across the eight new tests. This would help readability.

 Looking forward to helping test and get this committed! 🙌🏻

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/53450#comment:23>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform